Macro security, how to make it work

[Calab]

We have a spreadsheet that we use in Excel 2003. It's fairly awkward to find
the info that we need on the sheet.

I've since created a couple macros that really work well, but when I have
the macros attached to the spreadsheet, we get error messages about security
and the macros are disabled.

How can we avoid these errors and make the spreadsheet automatically load
the macros enabled, or at least pop up the "Do you want to enable macros"
messagebox?

There are too many workstations to simply drop the security to LOW, and that
probably isn't the best answer anyhow.

I could try a self signed certificate, but that probably won't do the job.

Is there anything that we can do?

 

[Harald Staff]

I've since created a couple macros that really work well, but when I have
the macros attached to the spreadsheet, we get error messages about
security and the macros are disabled.

What does the error messages say ?

I could try a self signed certificate, but that probably won't do the job.

Why would it probably not do the job?
Please explain.

Best wishes Harald

 

[mikebres]

Menu item Tools>Options then select the Security tab. Near the bottom you
will see a button labeled Macro Security... click on that and select the
level of security you want in the dialog that pops up. Some of the choices
will allow you to run macros or to choose whether you want to run them when
the spreadsheet is opened.