Running a macro with hidden sheets
 

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?

Running a macro with hidden sheets
 

Try to change Select with Activate:

Sheets("BINDING").activate


"JonathanW" wrote:

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?

Running a macro with hidden sheets
 

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.

--

Regards,

Halim


"JonathanW" wrote:

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?