Results 1 to 8 of 8

Unprotect, Execute Code, Reapply Protection for Multiple Sheets

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2010
    Location
    Layton, UT
    MS-Off Ver
    Excel 2013
    Posts
    73

    Unprotect, Execute Code, Reapply Protection for Multiple Sheets

    Hi and thanks in advance for you help.

    I have a workbook with multiple budget worksheet. In module 1 I have code to copy data from JANBUDGET to all the other budgets. All the worksheet are protected. I've figured out how to do what title of this post indicate what I want to do, but want to know if there is a more efficient way of doing this. I don't want to have 11 unprotect lines of code, then another 11 to reapply protection to FEB to DEC budget. I've attached the workbook. Can anyone tell me or modify the code to unprotect and re-protect all the budgets with fewer lines of code. I've enter the unprotect and re-protect lines for FEB and MAR, but don't want to do this for each budget.

    Catnap
    Last edited by catnam; 12-23-2011 at 02:56 PM. Reason: Attach file with solution

Thread Information

Users Browsing this Thread

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

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