BleepingComputer.com: Excel and setting edit object to be checked by default

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Excel and setting edit object to be checked by default

#1 User is offline   Bovinity 

  • New Member
  • Pip
  • Find Topics
  • Group: Members
  • Posts: 1
  • Joined: 16-January 12

Posted 16 January 2012 - 01:21 PM

Hi all, I have an excel sheet that is protected since there are many users. However, from time to time, a few people need to unprotect the sheet to make edits and we are running into a problem when we need to re-protect the sheet. When you protect the sheet, select locked cells and select unlocked cells are checked off by default but we have to remember to scroll down and also check off edit objects. This is causing a problem because sometimes the check off of edit object is forgotten which messes up the page for the rest of the users. Is there a way to set this box up to be checked by default just as the select locked cells and select unlocked cells are? Thanks for any advice!

#2 User is offline   Geoffc 

  • Member
  • PipPip
  • Find Topics
  • Group: Members
  • Posts: 46
  • Joined: 22-June 07
  • Gender:Male
  • Location:Warragul, Australia

Posted 28 January 2012 - 12:29 AM

The few complex ways you can give your members to make changes are too error-prone to bother with.

Best solution: You need a trusted monitor to receive all inputs and make changes.

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users