Posted to microsoft.public.excel.programming

da_gl

external usenet poster

Posts: 1

Disabling Button Commands in 2007

Historically you could disable Save, Save As, Exit, etc by using the
following:

Application.CommandBars("Worksheet menu
bar").Controls("File").Controls("Exit").Enabled = False

How to do this in Excel 2007?

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
command button commands to much	Wanna Learn	Excel Discussion (Misc queries)	1	October 27th 08 03:42 PM
Disabling of Cut and Paste commands on CELL	Mark	Excel Programming	2	April 7th 06 02:39 PM
Disabling ALL commands on CELL Shortcut menu	Peter Rooney	Excel Programming	3	August 16th 05 03:00 PM
commands button	pts	Excel Programming	1	June 24th 05 08:05 AM
Disabling Commands	Loomah	Excel Programming	1	January 16th 04 12:52 PM

All times are GMT +1. The time now is 11:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us