Macro with hidden worksheet

[graiggoriz]

Hello,

when I run that macro I have an error when I hide the worksheet "Consult2". Would you know anyway to have the macro running when the "Consult2" worksheet is hidden?

Many thanks,
Graig

[ARGK]

Hi Graig
A macro will not run on a hidden worksheet. However you can use this code to get round this problem.

Please Login or Register  to view this content.

This code will unhide your worksheet but NOT update the view, then run your code and hide your worksheet again. Change the "ThisSheet" entries in the code to the name of your worksheet.
Hope this helps.
Good luck.
Tony

[BrianM45]

Hi graiggoriz

Don't use "Select" with hidden worksheet

Try this code

Please Login or Register  to view this content.