Hi Guys,

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

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


---
Regards,
Norman



"kuansheng" wrote in message
oups.com...
Hi Guys,

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

Thanks a million Norman.