Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
JudiMicro
 
Posts: n/a
Default Protect shouldn't default to "allow users to select locked cells"

When making a form, cells are locked so that the user can not change them,
and can only enter information in the unlocked cells. But when one creates a
new form and then goes to protect it, Excel defaults to "allow users to
select locked cells". So you have to make an additional mouse move and
click to disable this function. Not efficient! And if there's a way to
change the default, I can't find it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup
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
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 10:02 PM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
Locked out of default file location Paul Donaldson Excel Discussion (Misc queries) 2 May 25th 05 10:01 PM
Protecting Workbook Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 12:55 PM
Gridlines: I want them to print default, not have to select it ev. jack ritterskamp Excel Discussion (Misc queries) 1 January 25th 05 05:04 PM


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