Hi All,

I seem to recall occasionally opening a workbook that has macros in it and,
upon asking Excel to 'disable macros', being informed that the workbook
contained macros written in Excel 4 which cannot be disabled.

In that situation, if I recall correctly, I was given two choices:

1) Open the workbook with the macros enabled; or
2) Don't open it at all.

At the time I was quite annoyed, but now it seems to me to be a good way to
avoid staff from disabling the macros within a shared workbook where I
really need for them to be active.

Is there still a way, using Excel 2000 (or Excel 97), to create an Excel 4
macro that will ensure users have to enable macros?

The macro does not need to do anything in particular I guess, just being
there should be enough?

Thanks in advance,

Alan.