B
Byers
how do I have a macro start upon the opening of a file if macros ar
enabled. I have set my workbook up so that it will display an erro
message on the start that says that macros must be enabled to use th
workbook, if they are, click here, if not, change the security leve
and reopen the file then click here. And the clicking there starts
macro that unhides the rest of the worksheets and hides the one wit
the error message. You may then carry on your way. I would prefe
that if macros are enabled that the macro automatically runs, however
don't want it to try to run if they aren't enabled.
any ideas
enabled. I have set my workbook up so that it will display an erro
message on the start that says that macros must be enabled to use th
workbook, if they are, click here, if not, change the security leve
and reopen the file then click here. And the clicking there starts
macro that unhides the rest of the worksheets and hides the one wit
the error message. You may then carry on your way. I would prefe
that if macros are enabled that the macro automatically runs, however
don't want it to try to run if they aren't enabled.
any ideas
pen() or put your code in the