S
Steve
Howdie all.
My colleague's ribbon macros are no longer working.
I've been working through his vba code, and checking each macro to see if
the code somehow got corrupted. So far all is clean, with no obvious errors.
I then rewrote one of macros from scratch and it works fine-- in both the
xml- ribbon, and in the vbe.
I then brought my ribbon over from my system(been working great, no errors)
to his and tried it. My ribbon, on his system, does not work now.
So far, we've checked the excel options, made sure that the macros are
enabled, no warnings, etc....
I've also tried opening the xlam files in XML Notepad, and I get the
following error message for all the xlam files.
Error loading C:\.......\filename.xlam
Data at the root level is invalid Line 1, position 1
would you like to open it with Notepad?
With the first file I said yes, and it opened up a file in notepad that
looked more like background computer gibberish- characters in no specific
order-- than it did my xml file.
I even tried opening my xlam file from my system and it go the same error
message. The weird thing isthat I'd taken my xlam file home months ago and
tried it in xml notepad there, with no errors of any kind. And the files all
open fine in CustomUI Editor, with no errors.
I've been reading more with the fairly new Ken Puls-R.Martin-T.Hennig Book-
RibbonX, and have tried some of the fixes, but it's still not working.
It's as though the macros have been unenabled in Excel, and regardless of
what I try-- make a new xml/xlam file, copy, rewrite from scratch, etc....
the entire code, the macros just no longer work.
I've reset the enable macros in options.
Have you ever seen where ribbon macros just fail, and no longer work?
Ifso, what kinds of fixes have you found that work?
Thank you.
My colleague's ribbon macros are no longer working.
I've been working through his vba code, and checking each macro to see if
the code somehow got corrupted. So far all is clean, with no obvious errors.
I then rewrote one of macros from scratch and it works fine-- in both the
xml- ribbon, and in the vbe.
I then brought my ribbon over from my system(been working great, no errors)
to his and tried it. My ribbon, on his system, does not work now.
So far, we've checked the excel options, made sure that the macros are
enabled, no warnings, etc....
I've also tried opening the xlam files in XML Notepad, and I get the
following error message for all the xlam files.
Error loading C:\.......\filename.xlam
Data at the root level is invalid Line 1, position 1
would you like to open it with Notepad?
With the first file I said yes, and it opened up a file in notepad that
looked more like background computer gibberish- characters in no specific
order-- than it did my xml file.
I even tried opening my xlam file from my system and it go the same error
message. The weird thing isthat I'd taken my xlam file home months ago and
tried it in xml notepad there, with no errors of any kind. And the files all
open fine in CustomUI Editor, with no errors.
I've been reading more with the fairly new Ken Puls-R.Martin-T.Hennig Book-
RibbonX, and have tried some of the fixes, but it's still not working.
It's as though the macros have been unenabled in Excel, and regardless of
what I try-- make a new xml/xlam file, copy, rewrite from scratch, etc....
the entire code, the macros just no longer work.
I've reset the enable macros in options.
Have you ever seen where ribbon macros just fail, and no longer work?
Ifso, what kinds of fixes have you found that work?
Thank you.