We have several workbooks on a server. Staff can access any of them at any
time.

So we could find out which books / sheets were being used I placed a
"counter" on a hidden sheet in each workbook. This works fine so long as
when the workbook is opened the person clicks to accept macros. It appears
many people click no, so the counter is never activated. (not because they
are affraid of virus's, more a case not knowing what it means and are
concerned in case they "change" the sheet some how.)

Is there a piece of code that I can use to automatically accept macros when
the workbook first opens ?

Any other suggestions as to how to resolve the above?

Bob

The whole point of the prompt is to enable users to disable macros if they
are not expecting a macro in the worksheet. There is no way to override this
security feature.

Ian

"Box 666" wrote in message
...
We have several workbooks on a server. Staff can access any of them at any
time.

So we could find out which books / sheets were being used I placed a
"counter" on a hidden sheet in each workbook. This works fine so long as
when the workbook is opened the person clicks to accept macros. It appears
many people click no, so the counter is never activated. (not because they
are affraid of virus's, more a case not knowing what it means and are
concerned in case they "change" the sheet some how.)

Is there a piece of code that I can use to automatically accept macros
when
the workbook first opens ?

Any other suggestions as to how to resolve the above?

Bob

Hi Bob,

As per the situation you have described "not because they are afraid of
virus's, more a case not knowing what it means", there is a way where you
can force the people to enable macros.

Just include one extra sheet lets say "warning" in your workbook and then
whenever the workbook is closed make this sheet visible and rest of the
legal sheets "very hidden". If the employee clicks on enable macros then in
the workbook open event unhide the good sheets and hide the warning sheet.
If the employee doesnt enable then they will only get the warning sheet and
hence they cannot do anything.

In the warning sheet you may put information like this:
"Please enable the macros in order to fill up the information. If macros are
not enabled the sheet cannot be worked upon.In case the security level of ur
Excel macro setting is set to High then, BEFORE opening the workbook, in
Microsoft Excel please go to Tools Macros Security. Within this choose
"Medium.You can choose whether or not to run potentially unsafe macros." and
choose press OK. Further when u open the workbook you will get a dialog box
in which choose "Enable Macros"."

If you want the relevant code in workbook_open , close event please post
back.

Regards,
Hari
India


"Box 666" wrote in message
...
We have several workbooks on a server. Staff can access any of them at any
time.

So we could find out which books / sheets were being used I placed a
"counter" on a hidden sheet in each workbook. This works fine so long as
when the workbook is opened the person clicks to accept macros. It appears
many people click no, so the counter is never activated. (not because they
are affraid of virus's, more a case not knowing what it means and are
concerned in case they "change" the sheet some how.)

Is there a piece of code that I can use to automatically accept macros
when
the workbook first opens ?

Any other suggestions as to how to resolve the above?

Bob