Re: Limiting the cells a command button can change

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/03/04 

Date: Tue, 3 Feb 2004 10:02:15 -0500

if Not intersect(selection,Range("B9:H20")) is Nothing then

change selection to activecell if that is preferred. 

-- 
Regards,
Tom Ogilvy
"Matt" <anonymous@discussions.microsoft.com> wrote in message
news:65220C8B-7F98-440B-8C55-397470BD4295@microsoft.com...
> 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