Posted to microsoft.public.excel.programming

Sam Kuo[_3_] Sam Kuo[_3_] is offline

external usenet poster

Posts: 86

How to disable all controls in form?

I'd like to disable a large number of controls and enable a small number of
controls (within a frame in a multipage) when click a button.

I'm guessing the quickest way to do this is to disable all controls then
enable the ones I need in code? But I don't know how to disable all controls
in a short way. Any ideas?

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
ActiveX Controls vs Form Controls	Alex	Excel Discussion (Misc queries)	1	January 11th 06 08:46 AM
Is it possible to disable two or more controls from the same toolbar, when those cont	Andoni[_50_]	Excel Programming	0	September 16th 04 02:28 PM
Enable and disable worksheet controls?	William Deleo	Excel Programming	8	December 23rd 03 12:59 PM
Disable app window controls	JC[_7_]	Excel Programming	0	November 25th 03 09:52 PM
Disable controls on spreadsheet	manishc	Excel Programming	1	November 16th 03 11:08 AM

All times are GMT +1. The time now is 06:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us