+ Reply to Thread
Results 1 to 5 of 5

Lock and protect formulas in Excel

  1. #1
    Registered User
    Join Date
    09-16-2019
    Location
    Goma, DRC
    MS-Off Ver
    Office 2016
    Posts
    2

    Lock and protect formulas in Excel

    Hello Everyone,

    I am working on a workbook that has many sheets with lot of formulas and I would like to know if there is a shorter way to lock and protect all the formulas in all sheets together. I know how to do it sheet by sheet but this is time consuming for me as I have many sheets.
    If you know a shorter way, that would be great.

    Thank you in advance,
    Mamy
    DRC

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Lock and protect formulas in Excel

    Please Login or Register  to view this content.

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: Lock and protect formulas in Excel

    Try this:
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  4. #4
    Registered User
    Join Date
    09-16-2019
    Location
    Goma, DRC
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Lock and protect formulas in Excel

    Thank you for for help but apparently there is no way to select two or more sheets and protect all of them together. Will continue to do it one by one.

  5. #5
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Lock and protect formulas in Excel

    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. lock / protect excel macros
    By manekankit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2019, 04:04 PM
  2. lock / protect excel macros
    By manekankit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2019, 03:59 PM
  3. [SOLVED] Lock and protect selected excel rows with VBA code
    By SmallJack in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-15-2015, 09:06 PM
  4. Marco to Lock/Unlock and Protect/Unprotect Multiple Excel Workbooks
    By Jgonza25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2013, 03:29 PM
  5. Can I protect/lock only the cells containing formulas?
    By JLee98 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2007, 10:17 PM
  6. Lock and password protect only cells with formulas on all sheets in a workbook
    By steve in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-10-2006, 03:29 AM
  7. How do I protect only formulas in Excel?
    By RHmcse2003 in forum Excel General
    Replies: 17
    Last Post: 06-21-2005, 02:05 PM

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