Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 Macros Will Not Run On A New Machine


20 Nov 2012   #1

Windows 7 Home Premium (Retail) Full version - With SP1
 
 
Excel 2010 Macros Will Not Run On A New Machine

Am running Windows 7 and Office 2010.

Several years ago I wrote four macros to perform operations in Excel 2010. Thet we to be placed in Personal.XLS so they would be available on all worksheets. I put links to them in the Quick Access bar. Twice I have tried to use those macros on different machines by putting the Personal.XLS from the first machine on to the new machines. They will not run from the either new machine's Quick Access bar but will run just fine from View/Macros/Run on each of the new machines. I get a message saying "Cannot run the macro "C:\Users\Main\AppData\Roaming\Microsoft\Excel\XLSTARTPERSONAL.XLS'!Sheet_Protection'. The macro may not be available in this workbook or all macros may be disabled."

The Trust Center Macro Settings has Enable all Macros checked.

The only way I have been able to use the Quick Launch Bar to run these macros is to delete and reinstall each of them. Then they work fine.

The only clue to what the problem may be is the User Name on each new machine is different.

Will someone please help me?

Thank you.

My System SpecsSystem Spec
.

20 Nov 2012   #2

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Does C:\Users\Main\AppData\Roaming\Microsoft\Excel\XLSTARTPERSONAL.XLS exist? check exact location and name.
I think the name should be C:\Users\Main\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLS instead. Are you logged on as user Main?
My System SpecsSystem Spec
20 Nov 2012   #3

Windows 7 Home Premium (Retail) Full version - With SP1
 
 

Quote   Quote: Originally Posted by Kaktussoft View Post
Does C:\Users\Main\AppData\Roaming\Microsoft\Excel\XLSTARTPERSONAL.XLS exist? check exact location and name.
I think the name should be C:\Users\Main\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLS instead. Are you logged on as user Main?
Thank you

Of course! My mistake. I left the '\' out. It does exist in that location and the macros in it work when, as I said, they are launched from View\Macros\Run but not from the Quick Access bar.

I really appreciate your reply for this has bugged me a while.

Thanks again.
My System SpecsSystem Spec
.


21 Nov 2012   #4

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

launch visual basic edit (in developer tab) and check if your code is in a sheet or module contained in the file you are working with
My System SpecsSystem Spec
21 Nov 2012   #5

Windows 7 Home Premium (Retail) Full version - With SP1
 
 

Quote   Quote: Originally Posted by Kaktussoft View Post
launch visual basic edit (in developer tab) and check if your code is in a sheet or module contained in the file you are working with
Thank you again.

My bad again!

The macros are in a module in Personal.xls.

BUT you had the answer in your first reply and ir went right over my head. You asked if I was logged in as MAIN. No I wasn't. I was logged in under another name. No wonder the buttons didn't work!

I created a user MAIN, logged into that name and things went perfectly. I can live with having to redo the buttons for the macros involved for now.

Thanks again for your help.
My System SpecsSystem Spec
21 Nov 2012   #6

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

LOL...
Do you want to enable the macros for ALL users on that machine? If so put personal.xls in folder C:\Program Files\Microsoft Office\Office 14\XLStart\ instead. Of course you have to modify Quick Access bar again. But only once!
My System SpecsSystem Spec
21 Nov 2012   #7

Windows 7 Home Premium (Retail) Full version - With SP1
 
 

Quote   Quote: Originally Posted by Kaktussoft View Post
LOL...
Do you want to enable the macros for ALL users on that machine? If so put personal.xls in folder C:\Program Files\Microsoft Office\Office 14\XLStart\ instead. Of course you have to modify Quick Access bar again. But only once!
That's to easy!

Thanks.
My System SpecsSystem Spec
21 Nov 2012   #8

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by jsquareg View Post
Quote   Quote: Originally Posted by Kaktussoft View Post
LOL...
Do you want to enable the macros for ALL users on that machine? If so put personal.xls in folder C:\Program Files\Microsoft Office\Office 14\XLStart\ instead. Of course you have to modify Quick Access bar again. But only once!
That's to easy!

Thanks.
So that's what you want? Works great?
My System SpecsSystem Spec
Reply

 Excel 2010 Macros Will Not Run On A New Machine




Thread Tools



Similar help and support threads for2: Excel 2010 Macros Will Not Run On A New Machine
Thread Forum
enabling macros in Excel Microsoft Office
Solved Virtual machine to try out Excel 64-bit Virtualization
Excel 2003 Macros do not run correctly on a Windows 7 system. Microsoft Office
excel 2010 Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel Macros Disabled Under W7 Microsoft Office
Running old Excel macros in Windows 7 Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:51 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33