View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Limit entry in range

at the beginning of your code for the button, check

Let us assume the button is designed to act on the activeCell

At the top of the sub fired when the button is clicked:
if intersect(activeCell,Range("B10:B50")) is nothing then exit sub

--
Regards,
Tom Ogilvy

smi wrote in message
...
Hello group,

Please help, I am using Excel 97 with Win 95. I have a button with VBA

code,
I need an other code to limit the user to use this button in some range

only
(B10:B50). The button with not work outside this limit.
Thank you very much for your time.

Long