Excel macro security

E

Ed Vogel

I´m developing an Excel application that will be used by hundreds of users
from Excel 97 to 2007. I´d appreciate some help in 2 issues. If someone could
indicate an technical document/site/forum, it would be great.

1) how to manage macro enabling issues for non advanced users. Most of them
can´t run the macros for security reasons and don´t know how to change macro
security levels, etc.

2) is it better to generate an application for each Excel version and
instruct the user to install the corresponding file of his/her version or
only one application of Excel 97 that is going to run in every case?

Thanks

Ed
 
W

ward376

Ed -
If someone could
indicate an technical document/site/forum, it would be great.

afaik, this is about the best group if you're developing Excel apps
1) how to manage macro enabling issues for non advanced users. Most of them
can´t run the macros for security reasons and don´t know how to change macro
security levels, etc.

A common approach is to set up a sheet with instructions on enabling
macros and explaining that macros have to be enabled for the file to
function. Hide all the other sheets and use code on file open to
unhide the ones required to run your app. If macros aren't enabled,
all the user(s) will see is the sheet with the enable instructions.
2) is it better to generate an application for each Excel version and
instruct the user to install the corresponding file of his/her version or
only one application of Excel 97 that is going to run in every case?

Since your users are "non-advanced" it's probably best to deal with
version differences in your code - although you may want to do it in
one file rather than multiple. (if I understand your question) Check
out Ron DeBruins site - he has some good examples of dealing with
version differences.
http://www.rondebruin.nl/

Cliff Edwards
 
E

Ed Vogel

Cliff

thanks for your quick reply. Your tips were very useful and I found some
good examples from Ron DeBruins site too.

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top