A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Make 2007 macros work in 2003



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2010, 10:58 PM posted to microsoft.public.excel.misc
SoilSaver
external usenet poster
 
Posts: 1
Default 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  
Old May 13th, 2010, 12:05 AM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.