PDA

View Full Version : How to unhide a sheet - xlveryhidden



Nonstopleo
09-08-2018, 10:26 PM
Hi friends
I need a help from you.
i have an excel sheet which has multiple sheets but all hidden except one.
hidden sheets are hidden by xlveryhidden option.

can anyone please advice me how I can change it to visible.

unfortunately, I dont have the password.

Kindly help.

Regards

Paul_Hossler
09-09-2018, 06:59 AM
xlSheetVeryHidden sheets cannot be made visible by the user, only using VBA, or manually in the project editor

I doubt you need a password to make it visible

Macro ...



Option Explicit

Sub ShowAll()
Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next
End Sub




… or manually


22847