excel hidden worksheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Hidden worksheets

Excel - Hidden worksheets

resolvedResolved · Low Priority · Version Standard

Michael has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access VBA course

Excel - Hidden worksheets

If you have a number of hidden worksheets is there an easy way to unhide them all or can they only be unhidden one at a time ?

RE: Excel - Hidden worksheets

Dear Michael

Thank you for attending Excel Advanced course.

Unfortunately there is not certain command to do what you are seeking but however with VBA you should be able to get the results.

Please follow these steps:

Step 1: Choose Tools> Macro > Visual Basic Editor... (Or ALT F11 to get the Visual basic Editor Window on the screen.

Step 2: Choose Insert > Module.

Step 3: In the module window copy and paste this:

Sub UnHideAll()

'unhide all sheets in a workbook

Dim sht As Worksheet

For Each sht In ActiveWorkbook.Sheets

sht.Visible = xlSheetVisible

Next

End Sub


Step 4: Click the [b Save Button [/b] and close the Visual Basic Editor Window.

Step 5: Choose [b] Tools> Macro> Macros

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips


Server loaded in 0.09 secs.