Roshin,
My suggestion is to hide the sheets whenever the workbook is closed
and saved. Then they will be hidden when the workbook is opened. That
means your opening routine won't need to hide them, but only unhide
them if opening routine is run and the password is correct.
James

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