+ Reply to Thread
Results 1 to 3 of 3

Automatic workbook protection

  1. #1
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Automatic workbook protection

    Hello,

    All my worksheet are protected with the password (P@sswod!) and when I need to edit an information, I go to view unprotect worksheet but sometime I forget to protect the worksheet back!

    Would you know any macro that allows me to have the CURRENT worksheet protected back or to have all my worksheets protected back with the pwd (P@ssword!) when I close/save the file (CTRL+S)???

    many thanks in advance,
    Graig

    note that my worksheet name are: January, February, March, April, May, June, July, August, September, October, November, December.
    Last edited by graiggoriz; 01-25-2016 at 05:29 AM.

  2. #2
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Re: Automatic workbook protection

    In fact, to have it simpler, would a macro can have the following worksheets: January, February, March, April, May, June, July, August, September, October, November, December set with the password: (P@sswod!) when I click on the save button (CTRL+S) ??

  3. #3
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Re: Automatic workbook protection

    Hello, I found that solution, I just need a hand to add the rest of the months. I tried Sheets("January","February") --> but it doesn't work. Any idea??

    HTML Code: 

+ 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. Replies: 8
    Last Post: 10-15-2015, 07:55 AM
  2. Remove automatic sheet protection after macro usage
    By aluKiller in forum Excel General
    Replies: 1
    Last Post: 07-05-2012, 08:12 PM
  3. Workbook Protection
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2010, 04:41 PM
  4. Automatic password protection
    By riggriff in forum Excel General
    Replies: 1
    Last Post: 01-27-2010, 12:59 PM
  5. workbook protection
    By miyat in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-11-2009, 10:12 AM
  6. [SOLVED] 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

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