Running a macro with hidden sheets

[Guest]

Hi,
I've just finished setting up my spreadsheet and starting hiding sheets that
users don't need to see, and I have a macro that no longer works since hiding
the sheet.
The code is:
Sheets("BINDING").Select
Is there any way I can still use this macro but hide the sheet?

 

[Guest]

Try to change Select with Activate:

Sheets("BINDING").activate

 

[Guest]

Hi Jon,

You cannot select or activate the hidden object, but you can change the
sheets contents by code.
Just like:
Sheets("BINDING").Range("A1").Value = "TestValue"

Altough Sheets("BINDING") is hidden.