Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mon Mon is offline
external usenet poster
 
Posts: 4
Default Protecting,Unlocked,&Check Boxes

Hi Everyone
I have a report that I am working on that has three check boxes. Certain
cells are hidden until the appropriate check box is checked (i.e. - check box
1 unhides columns A to J rows 11 to 21, check box 2 unhides columns A to J
rows 22 to 30, and check box 3 unhides columns A to J rows 32 to 40). I have
this worksheet protected as well as only the cells I want our employees to
tab to (unlocked). However, when I try to choose a check box when the sheet
is protected the cells that are unlocked so you can tab to them - I get an
error... or it says something about a "bug" ??? I don't get what I'm doing
wrong? Do I need a code for this?
I'm pretty new to all of this code writing and stuff like that, so ANY help
would be GREATLY appreciated.
Thanks!
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
Spell Check Unlocked Cells Only Dorci Excel Discussion (Misc queries) 9 August 5th 09 07:07 PM
Protecting Check Boxes to prevent editing Lindey Excel Discussion (Misc queries) 1 January 31st 08 10:17 PM
Can you spell check protected but unlocked cells in excel2000? MarkB Excel Discussion (Misc queries) 1 October 3rd 06 05:36 PM
Cells become unlocked and visible using a check box Luke Excel Discussion (Misc queries) 0 October 11th 05 06:13 PM
Spell Check an Unlocked Cell in a Protected Spreadsheet Jill E Excel Worksheet Functions 0 August 22nd 05 07:57 PM


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

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

About Us

"It's about Microsoft Excel"