As the other replies said, hide the sheets when the workbook is closed or
saved. Instead of setting the sheets' Visible property to False, you can set
it to xlVeryHidden. Sheets that are xlVeryHidden do not appear in the Format
Sheet Unhide dialog. Few users know how to unhide them.

Hope this helps,

Hutch

"roshinpp_77" wrote:


Hi friends,
I have a serious issue..Pls give some inputs...


I have an excel file which as 19 sheets.
i have made a macro which makes all the pages invisible except one when
the workbook is opened.
A login form is activated and only if a correct password is provided,
all the other sheets are made visible.

But my problem is..When the workbook is opened, a prompt dialog box
appears whether to enable or disable macro.

If the disable option is selected ..all the sheets are made visible..My
macro is of no use then...Please help


TIA

Roshin.P.P


--
roshinpp_77
------------------------------------------------------------------------
roshinpp_77's Profile: http://www.excelforum.com/member.php...o&userid=34924
View this thread: http://www.excelforum.com/showthread...hreadid=558385