Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 38
Default Option Box protected errror

I have option boxes from the "Forms" toolbar. On the sheet there are some
cells with formulas I would like protected. When I protect the sheet a
couple of things go wrong:

1. Everytime I click an option box the cell protected box pops up. I have
tried unlocking the cells the traditional way, as well as unlocking the
option box Format control. This problem persists.

2. The option box groupings misfunction. Usually I can only select one in
a group at a time. Once protected several can be selected and some
selections cause other option box to change with them.

Neither of these problems occur when the sheet is unprotected.

Any ideas would be greatly appreciated.
THanks,
Clint
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
How to show or hide outlined data option in a protected worksheet? Listasista Excel Discussion (Misc queries) 3 April 4th 23 11:36 AM
Object defined errror N.F[_2_] Excel Discussion (Misc queries) 1 July 11th 07 10:14 PM
Open a Protected file, I know the pw, not getting option to enter Charlotte Howard Excel Discussion (Misc queries) 2 February 20th 07 02:22 PM
system errror &H8000FFFF Harikarishna New Users to Excel 1 July 8th 06 02:01 AM
Do nested subtotals have an errror in Excel 2003 rlevitas Excel Discussion (Misc queries) 2 November 11th 05 06:46 PM


All times are GMT +1. The time now is 04:51 AM.

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"