+ Reply to Thread
Results 1 to 2 of 2

Enabling Add/Move new sheet in Protected Workbook

  1. 06-19-2018, 09:55 PM #1
    pchugh
    pchugh is offline
    Registered User
    Join Date
    05-04-2018
    Location
    Sydney, Australia
    MS-Off Ver
    2016
    Posts
    65

    Enabling Add/Move new sheet in Protected Workbook

    Hi Experts,

    I have a workbook that I have protected as I have hidden some sheets and I dont want users to be able to unhide those sheets. But I want the possibility to add new sheet or move a new sheet to this protected workbook. Is it possible with some VBA code to have these 2 functions in a Protected workbook.

    Thanks.
    Reply With QuoteRegister To Reply
  2. 06-19-2018, 10:12 PM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Enabling Add/Move new sheet in Protected Workbook

    Hi pchugh,

    See if Very Hidden is something you can use with your problem.

    https://www.excel-university.com/mak...t-very-hidden/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    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)

Similar Threads

  1. [SOLVED] Enabling filter on a protected sheet
    By KerryH 432 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2015, 11:32 AM
  2. Enabling vba-autofilters on a protected AND shared workbook
    By salsalex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2014, 09:57 PM
  3. Enabling Outlining (Groups) in a Protected Sheet
    By anguspgreenwood in forum Excel General
    Replies: 9
    Last Post: 01-20-2014, 10:02 AM
  4. enabling paste in protected sheet
    By cherryt in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-09-2013, 05:42 AM
  5. Enabling Grouping / Outline On A Protected Sheet VBA
    By SamuelT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2009, 06:21 AM
  6. Enabling Auto Filter when sheet is protected
    By nadiaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2007, 10:47 AM
  7. Enabling macros while the sheet being protected !
    By dinesh in forum Excel General
    Replies: 13
    Last Post: 09-27-2005, 03:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1