Posted to microsoft.public.excel.programming

Will

external usenet poster

Posts: 129

Enabling/Disabling multiple option buttons

I have an excel worksheet ("Sheet 1") with a number of Optionbuttons
all of which I want to disable
via macro which runs from another worksheet ("Sheet 2").

So I want to do something like this:

For i = 1 To 7
Sheets("Sheet 1").Controls("OptionButton" & i).Enable = False
Next i

Will this work?
Or am I missing something?

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
Enabling Option Buttons - Control	Andreww	Excel Programming	2	May 23rd 07 10:44 AM
Userforms: Disabling - Enabling the X	Lauri	Excel Programming	4	May 12th 06 07:02 PM
Disabling/Enabling Macros	HRobertson	Excel Programming	2	October 24th 03 04:07 PM
Enabling/Disabling Macros	David	Excel Programming	6	August 12th 03 06:21 PM
Option buttons - disabling	Ann	Excel Programming	1	July 23rd 03 01:04 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us