disabling security in Excel 97

[aharris2693]

I have created a program that is based completely off of the vba that runs when it is opened. I have now found out that some our older versions of excel were originally set up with a high level security. Part of the training that will go into using it will involve reseting the security levels to medium or low. My question is how do I do this on Excel 97. The security tab isn't under macro, and I can't find it in the customize section to add either. I know this is probably a very simple question, but I can't seem to find it anywhere on here.
Thanks for any help.

 

[Zathras]

Menu: Tools / Options
General tab: Uncheck the box that says "Macro virus protection"

But are you sure that's such a good idea? Do the users ever get spreadsheets from someone else? If so, perhaps it would be better just to have them see the warning message and then proceed.

Other possibilities include creating your application as an add-in, or installing code in their personal.xls workbooks.

 

[aharris2693]

Zathras
I don't mind if the prompt is there asking to enable or disable, but for users with 97, they aren't even getting this prompt. The message is saying that the macros are not digitally signed and therefore can't be opened. When you close the message box, it takes them into the spreadsheet, bypassing all of my opeining userforms that generate the information on the sheet. Thanks again

 

[Zathras]

Fascinating! I'm using Excel 97 SR-1 and when the "Macro virus protection" is checked I get a simple three-way choice:

Disable Macros / Enable Macros / Do Not Open.

It says nothing at all about digital signatures. Perhaps you can find out more at the Microsoft web site.

Maybe you will have to build your app using Excel 97. Or maybe there are some other options you haven't found yet. What version are you building with?