+ Reply to Thread
Results 1 to 6 of 6

Protect Structure

  1. #1
    Banned User!
    Join Date
    03-06-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    295

    Protect Structure

    Sorry I can see that everyone is busy so have a great day
    Last edited by billgyrotech; 10-05-2016 at 01:15 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,149

    Re: Protect Structure

    You didn't wait very long for a response. What was your question?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Banned User!
    Join Date
    03-06-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    295

    Re: Protect Structure

    This is what I posted before thank you for any help:


    I have attached an invoice workbook without the data. For some reason the user has been changing the worksheet names inadvertently on the existing worksheets. The 'Switchboard' worksheet is where the user adds more sheets as needed which works fine and auto numbers them. With the existing code for 'Protect All Worksheets' is there a way to edit this to not allow the user to change worksheet names once they have been added? Also I am concerned with this type of protection will it interfere with the 'Add More RPO Invoices' vba?


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 10-05-2016 at 04:17 PM. Reason: corrected closing code tag

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,149

    Re: Protect Structure

    I didn't find any 'Add More RPO Invoices' VBA.

    To prevent sheet name changes, protect the entire workbook:
    Please Login or Register  to view this content.
    To insert new sheets, temporarily unprotect then reprotect:
    Please Login or Register  to view this content.
    You can also add a password, similar to how you did it at the sheet level.

  5. #5
    Banned User!
    Join Date
    03-06-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    295

    Re: Protect Structure

    Oh sorry about that it is a macro called 'Copier'

    This is the macro for protecting:
    Please Login or Register  to view this content.
    Last edited by 6StringJazzer; 10-06-2016 at 12:37 PM. Reason: fixed code tag error

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,149

    Re: Protect Structure

    Right, you already posted that above. What I did not find was "Add More RPO Invoices". In any case, you can add the code I provided to the places where you need to protect sheets against renaming, and places where you need to add new sheets.

+ 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. Issues with "Protect Workbook Structure"
    By simon_geoghegan in forum Excel General
    Replies: 1
    Last Post: 04-09-2015, 12:40 PM
  2. [SOLVED] Unprotect/Protect Workbook Structure
    By Spear86 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2014, 04:26 AM
  3. Creating a Pyramid Hierarchy structure from a flat structure
    By thegamerulez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2014, 01:28 AM
  4. Replies: 0
    Last Post: 03-12-2013, 02:33 AM
  5. Replies: 2
    Last Post: 01-17-2013, 08:39 AM
  6. "convert" data with logfile structure to spreadsheet structure
    By boarders paradise in forum Excel General
    Replies: 7
    Last Post: 01-10-2011, 02:06 AM
  7. Protect Wbook Structure but allow Macros?
    By drewz80 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-30-2005, 07:53 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