Very hidden sheets

[markhotson]

Good day,
I have a workbook, lots of macros going on but none of them appear to create very hidden sheets.
Not only does the workbook contain very hidden sheets it creates new ones out of every new sheet I make, as soon as the book is closed and reopened the new sheet is very hidden.
I can unhide them each time no problem using a mnacro however I don't know how to unhide them permanently.

[torachan]

One way - Properties - VBA editor - alter each sheets 'visible' property.

Capture.JPG

[markhotson]

Thanks for that.
After running the unhide sheets macro all hidden sheets properties are set visible. However, even if I save, then close, they are all hidden upon reopening again.
Below is the unhide macro

Sub UnhideAllSheets()
Dim wks As Worksheet

For Each wks In ActiveWorkbook.Worksheets
wks.Visible = xlSheetVisible
Next wks
End Sub

[TMS]

It sounds as though there is a workbook open (or close) event handler that's looping through the sheets and setting them to very hidden.

[markhotson]

That sounds prommissing. How do I kill it

[davsth]

you first have to find it
press Alt F11 and go to the thisworkbook in the Microsoft Excel objects.

look to see if there are any events relating to open and close that have the xlhidden code in them

[TMS]

What davsth said . Or post a sample workbook so we can have a look.

[markhotson]

Much obliged

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.