+ Reply to Thread
Results 1 to 2 of 2

Protecting a Workbook

  1. #1
    Registered User
    Join Date
    01-03-2007
    Posts
    11

    Talking Protecting a Workbook

    Hiya, I'm back. So my workbook is awesome, I'm very happy with it. But now I need an EASY way to protect it so when I send it to my bosses I know they can't change it before sending it on again.

    I can't attach the .zip because now it's too big, sorry. There are five sheets: An instructions tab, two data tabs, and two PivotTable tabs. I know I can protect each sheet individually, but my first boss is the one who enters the data each time and I'm afraid he won't remember to re-protect each sheet every time he makes a change. Any suggestions?

    *goes to look other places as well* Thanks! ~RiverTam

  2. #2
    Registered User
    Join Date
    01-03-2007
    Posts
    11

    I'm talking to myself, must be Thursday...

    Okay, replying to myself, I have changed a setting in the workbook so there is a password needed to modify (and save the changes to) the document. This will work for now, but I'm really interested in an easy way to protect each sheet, so that no one else can even type anything. But without the hassle of having to unprotect and re-protect each sheet every time.

    Any help is appreciated, thanks! ~RiverTam

+ 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