+ Reply to Thread
Results 1 to 3 of 3

Protect Multiple Sheets at One Time

  1. #1
    Registered User
    Join Date
    01-21-2004
    Location
    Alabama
    Posts
    35

    Protect Multiple Sheets at One Time

    I was trying to protect multiple worksheets at a time. So i selected the tabs at the bottom and started unchecking the Locked check box after going to Format Cells. But what i found out was that it was unlocking the first sheet but not all the following sheets.

    I have 40 worsheets in this book and numerous elements per sheet, how can i protect several sheets at once? Am I required to protect them one at a time?

    All i wnat to do is prevent users from accidentally changing one of the formulas on the worksheets. It will throw off all the other calculations if the users mess up a formula since they are not smart enough to fix it.

    Thanks!

  2. #2
    Registered User
    Join Date
    01-21-2004
    Location
    Alabama
    Posts
    35
    I found this article on the Internet. http://support.microsoft.com/kb/142111

    But how do i lock and unlock cells on multiple sheets. I'm more concerned about this. Even if i can protect the sheets it matters little if people can't enter any information on the sheets at all.

  3. #3
    Registered User
    Join Date
    01-21-2004
    Location
    Alabama
    Posts
    35
    What appears to work is... If i format a sheet and unlock destinated cells and then cut and paste the worksheet on different tabs, the format is maintained. That way i don't have to format or unlock cells on each sheet.

    The only problem is that i will have to redo all my formulas yet again and I'm concerned about having to redo my conditional formatting also. And what about my print preview settings?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1