ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   creating form: I want to limit the tabs (https://www.excelbanter.com/excel-programming/423383-creating-form-i-want-limit-tabs.html)

Rotary Scott

creating form: I want to limit the tabs
 
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.

Tim Williams[_2_]

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.





All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com