Excel Macro question

eharlo01 · 09-11-2007, 11:45 AM

Long story short, I've built an excel workbook with several macros in it (macros saved to workbook). It works just fine on my PC, but it won't work on any other PC. I've saved it to our server, I've emailed it to people in my office and no one can get it to work on their computers. What am I missing here?

**Glaswegian** · 09-11-2007, 01:38 PM

Hi and welcome to TSF.

If your users have never used an Excel macro before, then it's probably their security settings that's causing the problem. In Excel, go to Tool > Options > Security Tab > Macro Security. Chances are the setting is High (MS default) - change it to Medium and OK back out. If they then receive a pop up when opening your workbook asking to enable or disable macros, you're all set.

eharlo01 · 09-11-2007, 01:45 PM

Security was the initial problem, but I changed their security levels and got them in. But the macro still wouldn't work. I had a button for them to press and it would run the macro. They could press the button but nothing happened. I even went in and assigned the macro to the button on their computers and nothing. Finally decided to save it as a "Word Template" versus just a Word Document and now everyone can run the macros on their own PC. Don't know why, but it works that way. I will have them enter the data, run the macro and then save the results as it's own Word Document. Should work just fine.

Thanks for your help.

09-11-2007, 11:45 AM	#1 (permalink)
eharlo01 Registered User Join Date: Sep 2007 Posts: 2 OS: XP	Excel Macro question Long story short, I've built an excel workbook with several macros in it (macros saved to workbook). It works just fine on my PC, but it won't work on any other PC. I've saved it to our server, I've emailed it to people in my office and no one can get it to work on their computers. What am I missing here?

09-11-2007, 01:38 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,449 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Excel Macro question Hi and welcome to TSF. If your users have never used an Excel macro before, then it's probably their security settings that's causing the problem. In Excel, go to Tool > Options > Security Tab > Macro Security. Chances are the setting is High (MS default) - change it to Medium and OK back out. If they then receive a pop up when opening your workbook asking to enable or disable macros, you're all set. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

09-11-2007, 01:45 PM	#3 (permalink)
eharlo01 Registered User Join Date: Sep 2007 Posts: 2 OS: XP	Re: Excel Macro question Security was the initial problem, but I changed their security levels and got them in. But the macro still wouldn't work. I had a button for them to press and it would run the macro. They could press the button but nothing happened. I even went in and assigned the macro to the button on their computers and nothing. Finally decided to save it as a "Word Template" versus just a Word Document and now everyone can run the macros on their own PC. Don't know why, but it works that way. I will have them enter the data, run the macro and then save the results as it's own Word Document. Should work just fine. Thanks for your help.