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