View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Prevent selection of cells, based on value of another?

AHHHH..... hmmmm... OK. Thanks.

"Ian" wrote:

Only with code.

--
Ian
--
"Stilla" wrote in message
...
Is there a way to prevent the selection of certain areas of a form, based
on
the value of an entry in one cell?

Say, if B1 is less than 3, then I want the user of the form to tab right
past the four next spaces. I've made them invisible based on the value of
B1
already with conditional formatting, but it would be nice if you could hit
the tab button without "stopping" at these cells.

THanks!