Thanks to both Mike H and Bob Umlas... exactly the result I was seeking.
My target audience, however, is likely to disable macros upon opening the
workbook... anyway to disable that warning?
There are t ways around it. One is to have your users set their macro
security to low. The down side is that if a workbook contains a virus then
they will open it without warning and get infected. A better option is to
digitally sign your work. That makes your work into a trusted source and the
book can open without need for the macro security alert... Check out this
link...
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.