Re: XL2007: Ribbon commands greyed-out after playing a macro

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

Peter.

"Jim Rech" <jrrech@xxxxxxxxxxx> schreef in bericht news:uixG4hhqHHA.3456@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Jim
"Peter" <scotsman@xxxxxxxxx> wrote in message news:4669c09f$0$27910$e4fe514c@xxxxxxxxxxxxxxxxxxxxxxxxxxx
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" <jrrech@xxxxxxxxxxx> schreef in bericht news:OPfxgdgqHHA.3740@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Jim
"Peter" <scotsman@xxxxxxxxx> wrote in message news:4669b301$0$18437$e4fe514c@xxxxxxxxxxxxxxxxxxxxxxxxxxx
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" <jrrech@xxxxxxxxxxx> schreef in bericht news:%23Mr%23l1fqHHA.1296@xxxxxxxxxxxxxxxxxxxxxxx
Is it a particular XLSM file or all?

--
Jim
"Peter" <scotsman@xxxxxxxxx> wrote in message news:46686214$0$7010$e4fe514c@xxxxxxxxxxxxxxxxxxxxxxxxxxx
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" <scotsman@xxxxxxxxx> schreef in bericht news:46686078$0$7048$e4fe514c@xxxxxxxxxxxxxxxxxxxxxxxxxxx
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










.

Loading