Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel and setting edit object to be checked by default


  • Please log in to reply
1 reply to this topic

#1 Bovinity

Bovinity

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:02:45 PM

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!

BC AdBot (Login to Remove)

 


#2 Geoffc

Geoffc

  • Members
  • 89 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Warragul, Australia
  • Local time:06:45 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users