Macro with hidden worksheet

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?

HTML Code: 

Many thanks,
Graig

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

Hi graiggoriz

Don't use "Select" with hidden worksheet

Try this code

Please Login or Register  to view this content.