New
#1
Excel 2010 Macros Will Not Run On A New Machine
Am running Win7 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.