XL2007: Ribbon commands greyed-out after playing a macro

[Peter]

Hi there,

In XL2007, the ribbon commands are greyed-out after playing a macro, at
least this has happened on my computer time after time (Vista Home Prof
Dutch).

Any thoughts on this?

Greetings,
Peter

 

[Peter]

Correction:
Already greyed out on opening the file, which occurs as Read-only
automatically. Propably because it is an .xlsm file. For this, refer to my
other question in this group: "XL2007: Read-only automatically applies to
..xlsm files"

 

[Jim Rech]

Is it a particular XLSM file or all?

--
Jim

Correction:
Already greyed out on opening the file, which occurs as Read-only
automatically. Propably because it is an .xlsm file. For this, refer to my
other question in this group: "XL2007: Read-only automatically applies to
.xlsm files"

 

[Peter]

That's a good question, Jim.

To try it out, I saved a new file with a macro as an .xlsm, and it didn't
happen again with that new file. but it keeps happening with the formerly
mentioned file. I guess these kinds of experiences are inherent to important
revisions of such software as xl. I'm anxiously awaiting what might be the
cause or solution to this problem.

Thanks for pointing this out, Jim.

Greetings,
Peter

 

[Jim Rech]

Since it's just a particular file I think the most likely reason is that the
file has 'ribbon altering' xml code in it. I'd be happy to check that out
for you if you want to send the file to me. If there is sensitive
information in the file (and even if there isn't) you can clear all the cell
contents completely so there nothing but blank worksheets in the file.

 

[Peter]

Hi Jim,

Boy, do you respond fast !! Thank you.

I accidentally discovered what went wrong just twenty minutes ago. Propably
a mouse mishap. Instead of signing my macro workbook at a particular point
in time, I seem to have chosen another option of the Prrepare menu item in
the Office menu, i.e. "Mark as final", because when I hovered my mouse
pointer over the greyed-out menu items of the ribbon, that is what the
menu-comment tells me about status of this file.

So, for future (and shorter) reference: choosing "Mark as Final" is
definately a reason for Excel to gey-out all ribbon-
menu-items. It may turn out that there are even more things that could make
this happen. I tried (while writing this response I thought of trying this)
to save the same file with a different name, but that doesn't resolve the
problem.
It seems that copying the data in the file to a new file is one solution,
though it'll cost you some time. But it does seem that Final is Final.

Thank you.
Peter

 

[Jim Rech]

Well, I've seen the "Mark as Final" command but never tried it. Shame on
me. Will the wonders of Excel 2007 ever cease?<g> Thanks for the
explanation.

 

[Peter]

To undo this "Final"-thing, just do it again, and the file is back to a
modifiable mode.

Peter.