xl Sheet Very Hidden

  • Thread starter Thread starter Harry
  • Start date Start date
H

Harry

While filling out my log book in excel I was trying out
some of the tools to see what they did.
Under the properties tool I have managed to make one of
my sheets in my work book hidden very well, the tab has
gone, and I can not see it by using Format Sheet Unhide.
Any help would be gratfully appreciated.
Yours Sincerely Harry Brouwer.
 
Hi Harry
This will hide xlsheetveryhideen and then unhide

Just replace the Sheet1 with the name of your sheet.


Sub HideunhideSheet()
'hide the sheet from the user cannot see from the
'format...sheet..unhide menu
Sheet1.Visible = xlSheetVeryHidden
'will make the sheet visable again
Sheet1.Visible = xlSheetVisible
End Sub
 
Back
Top