Forum

Hi Ken, There's multiple issues here and I can't get this code to run at all. Before I go through a few things to help there's a few things that y...

Hi Ken, So this is the same/similar to the qs you posted recently, or different? It's just that it's not working with a .xlsm when that xlsm file ...

no worries 🙂

Hi Bax, Sorry you can't do that with an embedded workbook either. Regards Phil

Hi Bob, As we'll be looping through every worksheet, but only saving some as PDF's, we need to have a way to flag that a sheet isisn't for exportin...

Hi Bax, If you hide a sheet that has a hyperlink to it, the hyperlink won't work. So there isn't a way to do this with an embedded workbook either...

Hi Maurizio, ActiveChart refers to the currently selected chart, see this If you select a chart before running the macro, you can just use Active...

Hi Julie, If you change the name of the workbook you want to get data from, then you need to change that same name in the formula you want to creat...

Hi Natasha, there's no attached workbook. Regards Phil

Hi Austin, I don't know what range you want to select, but if you want to select A1:A2 you can use this in your Workbook_Open() sub to replace the ...

No worries 🙂

Got it. When you prompt the user for input for the value of Payperdate, it's in the format xx/xx/xx The / are causing the issues because / isn't...

No worries Bob. I don't find anything logically wrong with your code, it doesn't generate an error on me. However, the value for Payperdate is emp...

Hi Bob, Without seeing all your code I can't be sure, and I can't run it to test it and see exactly what error messages you are getting, always bes...

Hi Austin, Event code must go in the container for the particular event you want. So for Workbook events the code must go in the ThisWorkbook modu...