Hide worksheet

[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

[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


---
Regards,
Norman



"kuansheng" <kuansheng@gmail.com> wrote in message
news:1139906090.042411.102940@g14g2000cwa.googlegroups.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
>

[kuansheng]

Thanks a million Norman.