Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default Worksheet Object Protection

I have an Excel worksheet with several text boxes and "objects/controls" that
were added from the "Control Toolbox" not from the "Forms" toolbox. I'm now
ready to "deploy" my worksheet/book and would like to lock EVERYTHING except
my end users ability to select the various check boxes, raido buttons, etc.
I can lock/protect it to generate an error when someone selects the objects,
or I can unprotect it so the end user can accidentially re-arrange/delete the
option buttons.

Please assist with providing an intermeiate security feature that would
allow the end user to select the various buttons without getting an error,
however, would not allow them to modify, move, or delete the buttons that are
already there.

Sincerely,

Christmas May
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
Cell Protection vs. Worksheet Protection kmwhitt Excel Discussion (Misc queries) 4 September 24th 06 02:37 AM
plot graph from multiple worksheet as embedded chart object on every worksheet jeftiong New Users to Excel 0 August 23rd 06 01:50 PM
Worksheet protection is gone and only wokbook protection can be se Eric C. Excel Discussion (Misc queries) 4 May 2nd 06 04:50 PM
List Object and Protection Jon Young Excel Worksheet Functions 0 January 11th 06 04:34 AM
Protect object vs. Protection from menu newbie Excel Programming 1 August 11th 04 04:13 PM


All times are GMT +1. The time now is 04:49 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"