Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

XL2007: Ribbon commands greyed-out after playing a macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter - 07 Jun 2007 20:45 GMT
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 - 07 Jun 2007 20:51 GMT
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"

> Hi there,
>
[quoted text clipped - 6 lines]
> Greetings,
> Peter
Jim Rech - 08 Jun 2007 19:47 GMT
Is it a particular XLSM file or all?

Signature

Jim

> Correction:
> Already greyed out on opening the file, which occurs as Read-only
[quoted text clipped - 12 lines]
>> Greetings,
>> Peter
Peter - 08 Jun 2007 20:49 GMT
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

> Is it a particular XLSM file or all?
>
[quoted text clipped - 14 lines]
>>> Greetings,
>>> Peter
Jim Rech - 08 Jun 2007 20:58 GMT
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.

Signature

Jim

> That's a good question, Jim.
>
[quoted text clipped - 27 lines]
>>>> Greetings,
>>>> Peter
Peter - 08 Jun 2007 21:47 GMT
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

> 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
[quoted text clipped - 34 lines]
>>>>> Greetings,
>>>>> Peter
Jim Rech - 08 Jun 2007 23:00 GMT
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.

Signature

Jim

> Hi Jim,
>
[quoted text clipped - 57 lines]
>>>>>> Greetings,
>>>>>> Peter
Peter - 09 Jun 2007 08:49 GMT
To undo this "Final"-thing, just do it again, and the file is back to a
modifiable mode.

Peter.

> 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
[quoted text clipped - 61 lines]
>>>>>>> Greetings,
>>>>>>> Peter

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.