Hide worksheet

K

kuansheng

Hi Guys,

I was wondering if it is possible to hide a worksheet from user view.
and let the worksheet work behind the scene
 
N

Norman Jones

Hi Kuansberg,

Try:
Format | Sheet | Hide

The user will be able to unhide the sheet by using the same menu path.

To hide the sheet more securely would require the use of VBA, e,g:

'=============>>
Public Sub Tester001()
Dim sh As Worksheet

Set sh = ActiveWorkbook.Sheets("Sheet2")
sh.Visible = xlSheetVeryHidden

End Sub
'<<=============

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top