Ed

Can be done but what contingency will you have if user chooses to disable macros
when opening the workbook?

Your macro won't run but the workbook will still open in it's useless state.

To properly set up for this type of operation, you would have code when closing
the workbook that hides all sheets except one which has nothing but a message
saying "You have disabled macros. Close workbook and re-open with macros
enabled"

If macros are enabled, workbook opens with sheets unhidden and macros ready to
go.

How do you want to proceed?


Gord Dibben MS Excel MVP

On Thu, 21 Dec 2006 11:20:01 -0800, Ed wrote:

Hello, I have a workbook that functions mainly through Macros, if you choose
not to run then then you can't get much done. I would like to have a macro
upon opening of the Workbook where a dialog box or whatever prompts the user
to type in a password, if the password is correct then nothing happens, but
if it is not, then it shuts down Excel... anybody know how?

thanks!