+ Reply to Thread
Results 1 to 3 of 3

Automatic workbook protection to the right level

  1. #1
    Registered User
    Join Date
    09-18-2020
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    1

    Lightbulb Automatic workbook protection to the right level

    Hello,

    I have to protect my workbook to prevent users from modifying my workbook cells with formulas in them. However, there are other cells that need to be edited and filled with text.

    To do spell check on those cells with text, the whole sheet needs to be unlocked and so I have created a spell check macro, that unlocks the sheet, does the cell spell checks and then re-protects it afterwards.

    However, when the macro re-protects my worksheet, it doesn't protect it with the same level of protection as before (where everything apart from delete columns was allowed), but only that you can click on locked and unlocked cells.

    Has anyone experienced this before? Can anyone please help as to to how I can have a macro that protects my sheet automatically with the same level of protection as before it was unprotected?

    Thank you!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,934

    Re: Automatic workbook protection to the right level

    You're going to need to share the code and, ideally, a sample workbook.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,934

    Re: Automatic workbook protection to the right level

    Maybe something like:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic workbook protection
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2016, 06:12 AM
  2. Two level sheet protection.
    By hbuzz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2015, 08:34 AM
  3. Posisible to Disable Save As at Program level (not workbook level)??
    By brian6464 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 02:49 PM
  4. Can't get VBA code to do task at worksheet level not workbook level
    By lealea1982 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2011, 10:22 AM
  5. Automatic Import: Very high-level question.
    By Ray C in forum Excel General
    Replies: 4
    Last Post: 10-22-2006, 06:30 PM
  6. [SOLVED] excel cell level protection
    By vijaytech in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 03:00 PM
  7. How do I stop Automatic Sheet/Workbook protection
    By Kim from AZ in forum Excel General
    Replies: 3
    Last Post: 08-17-2005, 09:05 PM

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.6.0 RC 1