Sorry that I have taken so long to get back to you, I just returned from vacation today.
When you opened the program with your security set at high it disabled the macro. Now that you have reset the security to medium, when you open a spreadsheet that has macros you should get a message that tells you that it includes macros and gives you the option to disable or enable the macros. Click the "enable" button (it will be the middle button). The macro should now work.
Email me at dpinkley@gmail.com to let me know whether or not this helped. If necessary, I could probably walk you through it over the phone.
Posted on: June 28, 2006Posted by:
Diane Gardner(c)
I can't get the name picker to run. This macro thing is very confusing. I like the sound of many of your ideas but if I can't get the free one to run then I can't purchase the others. Can you make this any easier? I went to tools, then macros and set it to medium. Now what? Thanks for any help.