+ Reply to Thread
Results 1 to 2 of 2

Protect structure of certain sheets in a workbook

  1. #1
    Registered User
    Join Date
    08-13-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    78

    Protect structure of certain sheets in a workbook

    Hi,
    I want to protect the ONLY Sheets 1,2 and 3 in my workbook.

    SO, I don't want the user to be able to delete / rename / hide the sheets 1,2 and 3 in the workbook. The workbook has additional sheets 4,5 and 6. The user should be able to hide / delete / rename any of these sheets except 1,2 and 3.

    Is there a way to achieve this with VBA ?

  2. #2
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Protect structure of certain sheets in a workbook

    Protect Workbook
    Open a workbook.
    On the Review tab, in the Protect group, click Protect Workbook.
    Check Structure, enter a password and click OK. Note: The Windows option is not available in Excel 2013 and later versions.
    Reenter the password and click on OK.

    Is this what you are after
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

+ 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. Protect Structure
    By billgyrotech in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2016, 12:39 PM
  2. Issues with "Protect Workbook Structure"
    By simon_geoghegan in forum Excel General
    Replies: 1
    Last Post: 04-09-2015, 12:40 PM
  3. [SOLVED] Unprotect/Protect Workbook Structure
    By Spear86 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2014, 04:26 AM
  4. Replies: 0
    Last Post: 03-12-2013, 02:33 AM
  5. VBA to summerize the workbook sheets data in a required structure
    By ravikumar00008 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-12-2012, 11:44 AM
  6. Workbook structure protection for opnly specified sheets
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2012, 01:36 PM
  7. Replies: 1
    Last Post: 10-28-2010, 12:48 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