Unhide worksheet?

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

Other than fm Format > Sheet > Unhide to reveal hidden worksheets, wat other
methods is used to hide a worksheet?
 
Hi

Macro code:

Sub ShowSummary()
Sheets("Summary").Visible = True
End Sub
 
Hi

You can set the worksheet's Visible property to xlSheetVeryHidden from sheet
properties in VBA Project window or through code. User can't set the very
hidden sheet visible again from Format.Sheet.Unhide otherwise, but only from
VBA Project window or through code again.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rows won't unhide 5
Custom View: Keeping worksheet hidden? 1
Expand and collapse rows 7
Unable to unhide hidden columns 3
Unhide Worksheet 2
Unhide rows? 1
Unhide command? 2
Unhide Multiple Sheets at once 8

Back
Top