View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default creating form: I want to limit the tabs

Protect the sheet, unlocking only the cells you need for data entry.
Tools Protection Protect sheet
There's an option to prevent selection of locked cells.

Tim

"Rotary Scott" <Rotary wrote in message
...
I am creating a procurement form for my Rotary club's auction and I am
tired
of paper forms but need something simple.

I understand how to insert tables but how do I limit people from tabbing
out
of the form or into a place that I have typed into?

Very much appreciate your time and help.