Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting the cells a command button can change
I have a command button that when clicked, it changes some of the cell properties. I would like to limit the cells that the command button can change. I would like to say that if the activecell is within a range, then make the changes. Otherwise if not, exit sub. I'm not sure how to write the code so that the button is limited to a certain range of cells. Thanks for any help. Matt
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting the cells a command button can change
if Not intersect(selection,Range("B9:H20")) is Nothing then
change selection to activecell if that is preferred. -- Regards, Tom Ogilvy "Matt" wrote in message ... I have a command button that when clicked, it changes some of the cell properties. I would like to limit the cells that the command button can change. I would like to say that if the activecell is within a range, then make the changes. Otherwise if not, exit sub. I'm not sure how to write the code so that the button is limited to a certain range of cells. Thanks for any help. Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change color of command button | Excel Discussion (Misc queries) | |||
Where is toolbar command button to change percentage of screen? | Excel Discussion (Misc queries) | |||
CHANGE DATA SERIES WITH A COMMAND BUTTON | Charts and Charting in Excel | |||
Change Name of Command Button | Excel Discussion (Misc queries) | |||
Change active cell properties with command button | Excel Programming |