I would like to not allow a user to open a workbook if she/he does not enable
macros when prompted. Is there a cool way to do this? I have some code in
the Workbook_Open that must run when the workbook is open. Thanks.

If macros are not enabled, no code runs.

"Roxy" wrote:

> I would like to not allow a user to open a workbook if she/he does not enable
> macros when prompted. Is there a cool way to do this? I have some code in
> the Workbook_Open that must run when the workbook is open. Thanks.

the common way most deal with this problem is to hide all but one sheet when
saving & closing your workbook. This sheet would be displayed when macro's
are not enabled next time workbook is opened, showing a message informing
user that macro's must be enabled.
If however, macros are enabled then other worksheets are unhidden & message
sheet hidden.
Sounds tad complicated but can be made to work for most uses.
Have a look at this site for some idea how to approach the problem. You can
google other sites for further samples
http://www.dotxls.com/excel-security...e-excel-macros

Hope helpful


--
jb


"Roxy" wrote:

> I would like to not allow a user to open a workbook if she/he does not enable
> macros when prompted. Is there a cool way to do this? I have some code in
> the Workbook_Open that must run when the workbook is open. Thanks.

Nice answer John! Thinking 'out of the box'.
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk


"john" wrote:

> the common way most deal with this problem is to hide all but one sheet when
> saving & closing your workbook. This sheet would be displayed when macro's
> are not enabled next time workbook is opened, showing a message informing
> user that macro's must be enabled.
> If however, macros are enabled then other worksheets are unhidden & message
> sheet hidden.
> Sounds tad complicated but can be made to work for most uses.
> Have a look at this site for some idea how to approach the problem. You can
> google other sites for further samples
> http://www.dotxls.com/excel-security...e-excel-macros
>
> Hope helpful
>
>
> --
> jb
>
>
> "Roxy" wrote:
>
> > I would like to not allow a user to open a workbook if she/he does not enable
> > macros when prompted. Is there a cool way to do this? I have some code in
> > the Workbook_Open that must run when the workbook is open. Thanks.