Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 30
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allowing only 1 check box to be ticked Nadia Excel Discussion (Misc queries) 12 November 28th 09 10:55 PM
Copying forumla for vlook up but changing the column Index # klafert Excel Worksheet Functions 21 September 4th 06 07:56 PM
Enable check box in protected sheet + group check boxes Dexxterr Excel Discussion (Misc queries) 4 August 2nd 06 12:00 PM
Check boxes I have inserted in Excel move when I print? Mechelle C Excel Discussion (Misc queries) 1 June 22nd 06 06:44 PM
Can Not Check more than 1 check box jamphan Excel Discussion (Misc queries) 1 May 5th 06 04:58 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"