ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I control to which cells a user adds data? (https://www.excelbanter.com/excel-worksheet-functions/8243-how-do-i-control-cells-user-adds-data.html)

pmo3

How do I control to which cells a user adds data?
 
I would like to have a tab order set up on a worksheet for a user to only
access certain cells to input data.

I am not using UserForms and have only 2 sets of option buttons from the
Control toolbox.

Frank Kabel

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0008.html

--
Regards
Frank Kabel
Frankfurt, Germany

pmo3 wrote:
I would like to have a tab order set up on a worksheet for a user to
only access certain cells to input data.

I am not using UserForms and have only 2 sets of option buttons from
the Control toolbox.





All times are GMT +1. The time now is 03:53 AM.

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