+ Reply to Thread
Results 1 to 1 of 1

Protection of Three Sheets

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    324

    Protection of Three Sheets

    My workbook includes three sheets. Each of them has locked cells. The Sheets all currently have code on the Sheet to protect the sheet when it is activated and different code when they are deactivated. The code is different on each as the requirements for Protection are different - some allow locked cells to be selected - others don't.

    What would the code look like to do the following and where would the code sit - on the sheets or as a call ??

    If one of the Sheets becomes unprotected then the other two are set to Unprotect and when none of the Sheets has been active for 60 seconds then each of eth sheets becomes protected.

    Thank You

    Allister
    Last edited by AllisterB; 07-21-2020 at 01:47 PM.

+ 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. Length and distance from the line coordinate and point coordinate
    By sanju2323 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2019, 03:13 PM
  2. Help With Protection For Sheets Using Macros
    By rahul_ferns76 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2017, 08:33 PM
  3. Protection sheets problem
    By jasonj in forum Excel General
    Replies: 3
    Last Post: 12-03-2010, 05:55 AM
  4. return value of X coordinate and Y coordinate?
    By sbmoller in forum Excel General
    Replies: 1
    Last Post: 09-22-2007, 06:54 AM
  5. Protection and hidden sheets
    By daddioja in forum Excel General
    Replies: 1
    Last Post: 02-15-2007, 10:03 PM
  6. Protection of many sheets
    By Adam in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-26-2006, 11:15 AM
  7. [SOLVED] Protection and Hiding Sheets
    By JudithJubilee in forum Excel General
    Replies: 4
    Last Post: 03-04-2005, 11:06 AM

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