View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Hiding Worksheets

Open the VB Editor and in the Immediate Window use the first line below to
hide the worksheet
Make it visible again with the second line

worksheets("sheet2").Visible = xlSheetVeryHidden
worksheets("sheet2").Visible = true
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RF Guy" <RF wrote in message
...
In Excel 2007 is it possible to hide a worksheet within a workbook with
password protection so it cannot be viewed by others?

Thanks!

Steve