+ Reply to Thread
Results 1 to 5 of 5

Macro to protect all but one sheet

  1. #1
    Registered User
    Join Date
    03-01-2007
    Posts
    47

    Macro to protect all but one sheet

    Hello,

    I am running the following code at workbook open:

    Please Login or Register  to view this content.
    I need this for the functioning of all the sheets except one that I just added. The new sheet will not function with the above settings, and should remain unprotected. Any help tweaking the code would be great. The name of the sheet that I don't want protected is "CBList".

    Thank you,
    Jason
    Last edited by Jason_2112; 11-11-2010 at 10:34 AM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Macro to protect all but one sheet

    Please Login or Register  to view this content.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Macro to protect all but one sheet

    Try
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    03-01-2007
    Posts
    47

    Re: Macro to protect all but one sheet

    Perfect. I got Roy's to work, but the first one was giving an error when opening the workbook. Problem solved though. Thanks for the speedy help guys.

    - Jason

  5. #5
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Macro to protect all but one sheet

    No worries.

    Code shouldn't have caused an error but at least you've got it sorted.

    Dom

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1