• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Protecting Multiple Sheets

kjkrsch

New Member
I have a spreadsheet in which I have 26 sheets, one for each pay period of the year. On each sheet the users need to be able ot input information but there are areas that I don't them editing so I protected those areas. However when a change needs to be made it becomes very time consuming.


Is there a way to protect and un-protect multiple sheets at once?


I am a padawon striving to become a great excel knight...basically my expereince and skills are limited so please keep it "barney simple". Thank you in advance for your support.
 
Back
Top