Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make 2007 macros work in 2003
I made a survey in Excel 2007 with macros that will unhide rows based on the
value of another cell. I saved it first with .xlsm extension, and when a user opened it in Excel 2003, it was read only. I then saved it with .xls and the user was never promted to enable macros when they opened it, but, after some digging, was able to enable macros and use the form. This survey is going to non-technical people who won't know how to dig around to enable their macros. It has to be obvious. Is there a way for someone with Excel 2000 or 2003 to easily open and use this document? I don't have a way to test it myself in 2003, so I'm just relying on what my test users in remote places are telling me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make 2007 macros work in 2003
If the workbook contains macros the users will have to set their security to
medium so's they receive the warning about enabling macros. Or you buy a digital certificate and sign the workbook. Gord Dibben MS Excel MVP On Wed, 12 May 2010 14:58:01 -0700, SoilSaver wrote: I made a survey in Excel 2007 with macros that will unhide rows based on the value of another cell. I saved it first with .xlsm extension, and when a user opened it in Excel 2003, it was read only. I then saved it with .xls and the user was never promted to enable macros when they opened it, but, after some digging, was able to enable macros and use the form. This survey is going to non-technical people who won't know how to dig around to enable their macros. It has to be obvious. Is there a way for someone with Excel 2000 or 2003 to easily open and use this document? I don't have a way to test it myself in 2003, so I'm just relying on what my test users in remote places are telling me. |
#3
|
|||
|
|||
Quote:
electronic signature Last edited by martincrow : May 19th 11 at 07:49 AM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make macro run other macros in Exc 2007,no problems in Exc 2003 | Excel Discussion (Misc queries) | |||
Make Excel 2007 work like 2003 | New Users to Excel | |||
I was using Excel 2007, now 2003 and my Macros won't work | Excel Worksheet Functions | |||
how can i make macros to work when in tools, costumize and option. | Excel Worksheet Functions | |||
How can I make Excel Macros created on PC work on Macintosh? | Excel Worksheet Functions |