+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    08-24-2009
    Location
    Chicago, US
    MS-Off Ver
    Excel 2003
    Posts
    9

    Angry Worksheet/Book Protection

    Hi,
    So I want to protect a work book that contains 50 sheets. I dont want people to be able to edit the contents of each individual sheet without having a password.


    I tried the following; tools---> protection----> protect workbook---> structure, but people could still edit the actual contents of each sheet


    I know I could individually protect each sheet, but since I have a few of these 50+ sized workbooks to do, that would be a huge waste of my time

    Anyone think of a better way (preferrably non-VBA)?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Cochrane,Alberta
    MS-Off Ver
    XL 2003,2007
    Posts
    6,259

    Re: Worksheet/Book Protection

    Dave


Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.2.0