+ Reply to Thread
Results 1 to 3 of 3

ActiveSheet Unprotect to Userform open, and ActiveSheet Protect to Userform close

  1. #1
    Registered User
    Join Date
    12-01-2019
    Location
    Europe
    MS-Off Ver
    2016
    Posts
    35

    ActiveSheet Unprotect to Userform open, and ActiveSheet Protect to Userform close

    Hello everyone, an example in the attached file.
    I have two sheets, one is protected with code 123,
    can you please customize vba code when the form opens to become ActiveSheet Unprotect?
    and when the form closes to become ActiveSheet Protect?

    I repeat only when opening and closing the form.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: ActiveSheet Unprotect to Userform open, and ActiveSheet Protect to Userform close

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-01-2019
    Location
    Europe
    MS-Off Ver
    2016
    Posts
    35

    Re: ActiveSheet Unprotect to Userform open, and ActiveSheet Protect to Userform close

    Thank you very much

+ 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. VBA Userform Next and Previous Buttons that work on current activesheet/open sheet
    By pumashoes in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-23-2020, 09:30 AM
  2. ActiveSheet.Unprotect("pass") / ActiveSheet.Protect ("pass") breaks functionality
    By Proventus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-02-2016, 10:30 PM
  3. [SOLVED] Userform Listbox to Activesheet.Range(Activecell.address).Value Error
    By Spyderz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-26-2012, 04:59 PM
  4. [SOLVED] Userform on Activesheet
    By BobBlooms in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2012, 12:01 PM
  5. [SOLVED] UserForm to work on ActiveSheet
    By 55horses in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2012, 10:26 AM
  6. Change UserForm Depending on ActiveSheet?
    By jonn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2007, 09:02 AM
  7. [SOLVED] ActiveSheet.Unprotect
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2005, 08: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