Excel Macro Funkiness
-
Every new year, I create new logs for our trim shop...basically by taking the current sheet, removing old worksheets and making it ready for the next year and renaming for the new year.. Of the 4 logs, one of them is giving me problems.
Basically, when they click on a Macro Called New Sheet, it basically takes the same format of the sheet before it and creates a new Worksheet in the same workbook for the date picked form the calendar pop up. What it is not doing is carrying over the Macro Buttons (4 in all) to the new sheet. This happens on all PC's (either Excel 2010 or 2013) except my PC. Works perfectly on mine. Every other PC, no Macro Buttons carried over to the new sheet. This is baffling. I've tried saving in it's current format of Office 97-2003 and in current 2013 Macro Enabled format. Nothing works...
Any clue offhand without the need to post the code? Something is "right" on my PC and wrong on all others...so weird...
-
@garak0410 said:
Every new year, I create new logs for our trim shop...basically by taking the current sheet, removing old worksheets and making it ready for the next year and renaming for the new year.. Of the 4 logs, one of them is giving me problems.
Basically, when they click on a Macro Called New Sheet, it basically takes the same format of the sheet before it and creates a new Worksheet in the same workbook for the date picked form the calendar pop up. What it is not doing is carrying over the Macro Buttons (4 in all) to the new sheet. This happens on all PC's (either Excel 2010 or 2013) except my PC. Works perfectly on mine. Every other PC, no Macro Buttons carried over to the new sheet. This is baffling. I've tried saving in it's current format of Office 97-2003 and in current 2013 Macro Enabled format. Nothing works...
Any clue offhand without the need to post the code? Something is "right" on my PC and wrong on all others...so weird...
I know there is a macro-enabled format for Excel. I think it's xlsxm is the format. You say you've tried that but I assume Macros are enabled and allowed on the other machines?
-
You can setup GPO's to produce results like this (banning macros) - check for them (dont remember what they're called)
Essentially they setup the security levels in Office.Next up, antivirus - same across the board?
After that, admin privilages - are you logged in with the same account for all of this?
-
@thanksaj said:
@garak0410 said:
Every new year, I create new logs for our trim shop...basically by taking the current sheet, removing old worksheets and making it ready for the next year and renaming for the new year.. Of the 4 logs, one of them is giving me problems.
Basically, when they click on a Macro Called New Sheet, it basically takes the same format of the sheet before it and creates a new Worksheet in the same workbook for the date picked form the calendar pop up. What it is not doing is carrying over the Macro Buttons (4 in all) to the new sheet. This happens on all PC's (either Excel 2010 or 2013) except my PC. Works perfectly on mine. Every other PC, no Macro Buttons carried over to the new sheet. This is baffling. I've tried saving in it's current format of Office 97-2003 and in current 2013 Macro Enabled format. Nothing works...
Any clue offhand without the need to post the code? Something is "right" on my PC and wrong on all others...so weird...
I know there is a macro-enabled format for Excel. I think it's xlsxm is the format. You say you've tried that but I assume Macros are enabled and allowed on the other machines?
Well, when saved in Maco-Enabled format, the macro buttons then become unclickable to everyone except me. No other security or AD security informnation has been changed. Nothing different done to this sheet this year that we didn't do last year.
-
@MattSpeller said:
You can setup GPO's to produce results like this (banning macros) - check for them (dont remember what they're called)
Essentially they setup the security levels in Office.Next up, antivirus - same across the board?
After that, admin privilages - are you logged in with the same account for all of this?
Good tips...we've never had a GPO or any kind of AD permission changes at all. We are so Macro Heavy here that everyone has permission to run Macros.
I thought about the Admin privileges but my manager, who is the only other domain admin, has the same problems as the other PC's. I seem to be the only one who can make this sheet work as it should.
I had another user on Office 2010 take a 2 year old copy of this sheet (same macros, never changed in years) and the Macros work for him. I then had him save it as Macro Enabled and name it test01. He exited and went back into test01 and bam, Macro's not working...can't click on the buttons. I copied that test01 to my machine and it works. Sent it to my manager, who has same permissions as me, buttons do not work.
-
Guess what? It was related to this issue: http://support.microsoft.com/kb/3025036/EN-US
-
@garak0410 Not to worry then, they even have a thing that will "fix it for you" .... uh huh
