Sorry I can see that everyone is busy so have a great day
Sorry I can see that everyone is busy so have a great day
Last edited by billgyrotech; 10-05-2016 at 01:15 PM.
You didn't wait very long for a response. What was your question?
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.
Last edited by 6StringJazzer; 10-05-2016 at 04:17 PM. Reason: corrected closing code tag
I didn't find any 'Add More RPO Invoices' VBA.
To prevent sheet name changes, protect the entire workbook:
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.Please Login or Register to view this content.
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks