ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I get the focus on a check box? (https://www.excelbanter.com/new-users-excel/110000-how-do-i-get-focus-check-box.html)

reneatwork

How do I get the focus on a check box?
 
I've built a form in Excel. I've protected it. When the user is tabbing
down through the form I want it to stop at the check box so the person can
check it. Also, how do I change it from checking it with the mouse to just
hitting the space bar and having it check?

Office Helper

How do I get the focus on a check box?
 
Before you protect it. Right click on the check box, go to the Protection
tab and uncheck Lock Cells. Then reprotect. You should be able to click the
checkbox now.

"reneatwork" wrote:

I've built a form in Excel. I've protected it. When the user is tabbing
down through the form I want it to stop at the check box so the person can
check it. Also, how do I change it from checking it with the mouse to just
hitting the space bar and having it check?



All times are GMT +1. The time now is 07:16 PM.

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