Posted to microsoft.public.excel.programming

Ken[_28_]

external usenet poster

Posts: 2

Ribbon and toolbar, program control

I need to hide/redisplay (turn off or on) Excel's ribbon and quick access
toolbar from within a macro. This was easy enough in the older Excels but I
can't figure it out in Excel 2007. If I turn them off and on directly while
recording, all I get is a blank maco. Any help out there? Thanks!

--Ken

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I get defaullt toolbar or ribbon in MS Office 2007?	$$$	Excel Discussion (Misc queries)	2	December 4th 09 05:39 PM
Expand/collapse toolbar ribbon	jday	Excel Programming	6	April 15th 09 09:41 PM
Expand/collapse toolbar ribbon	Rick Rothstein	Excel Programming	0	April 14th 09 07:08 PM
Modifying XLA to show toolbar in XL 2003 and ribbon tab in XL 2007	jean grey	Excel Programming	4	January 28th 09 05:14 AM
toolbar/ribbon hide/show macro	barrowhill	Excel Programming	2	July 26th 07 07:56 PM

All times are GMT +1. The time now is 04:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us