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