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.

Don't knoiw why macros not run on friends machine but

"I've also tried opening the xlam files in XML Notepad, "

xlam file is not xml. it is a zip that holds many files, some xml and some
not. so it not open right in xml notepad.

"And the files all open fine in CustomUI Editor, with no errors."

that editor is not xml editor but a specal program that pull ribbon xml from
'customui.xml' file in xlam for changing and save it back.

H


"Steve" wrote in message
...
| 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.
|