Enabling macros for my workbook

[Maddoktor]

Is it possible to not open a workbook (either through Excel or
double-clicking the file in explorer) if macros are automatically
disabled or the user decides not to enable the macros?

If so, I would like for it then to display a msgbox informing the user
that macros must be enabled to view or edit the workbook.

Thanx in advance.

[Bob Phillips]

The standard way to approach this is as follows.
- create a worksheet with a message on it explaining that for this workbook
to
run it needs macros enabled, maybe even a few screenshots
- hide all other worksheets
- add some code in the Workbook_Open event that unhides the other sheets,
but hides that sheet.


What happens is that if they do not enable macros, they will only see the
warning sheet, telling them how to do it. If they enable macros, it will
startup as the workbook it should be.


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Maddoktor" <maddoktor@clinic.com> wrote in message
news:OYabqxgOGHA.208@tk2msftngp13.phx.gbl...
> Is it possible to not open a workbook (either through Excel or
> double-clicking the file in explorer) if macros are automatically
> disabled or the user decides not to enable the macros?
>
> If so, I would like for it then to display a msgbox informing the user
> that macros must be enabled to view or edit the workbook.
>
> Thanx in advance.