How to resolve "Unable to set the Visible property of the worksheet class"

[Keletso]

Good Day,

My name is Keletso I am in South Africa employed in the government Treasury

I am starting to learn excel VBA and as i am working with budgets databases for the province.

I am trying to hide worksheets that i do not need to see or work with however, I am getting the message "Unable to set the Visible property of the worksheet class"

Please help

 

[vletm]

Keletso
How do You try to hide worksheets?

 

[Keletso]

Hi vletm

Unprotect the worksheet, right click and select unhide, i will then choose which sheet i want to hide on the worksheet

 

[Keletso]

vletm

So since this route is not going through I
* Open the Visual Basic Editor
*go to VBA Project window, select worksheet i want to hide
*Set the visible property to -1 xlSheetVisible

 

[vletm]

Keletso
You asked about with VBA ...
Have You any code yet?
Could You create a sample Excel-worksheet
... , which shows Your case better?
... , which shows Your challenge?

 

[p45cal]

Are you trying to hide he last visible sheet? It won't let you.