+ Reply to Thread
Results 1 to 2 of 2

Protecting Multiple Sheets

Hybrid View

  1. 04-13-2013, 11:36 AM #1
    aresquare1
    aresquare1 is offline
    Forum Contributor
    Join Date
    04-15-2008
    Location
    Texas, USA
    MS-Off Ver
    M365 Excel Version 2210
    Posts
    216

    Protecting Multiple Sheets

    I have a workbook to be distributed. It has 22 sheets and each one will need protecting. Is there a way to do that for all sheets or do you have to save EACH sheet at a time?

    Thanks,
    RR
    Reply With QuoteRegister To Reply
  2. 04-13-2013, 12:00 PM #2
    AndyLitch
    AndyLitch is offline
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Protecting Multiple Sheets 

    Sub ProtectWorksheets()
Dim Ws As Worksheet
    For Each Ws In Sheets
        ws.protect password:= "password"
    Next Ws
End Sub
    Elegant Simplicity............. Not Always
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1