Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a worksheet that the first tab is the template named "Template", what
I want to happen is I have a command button on the form called "New Entry" which copies the tab and makes "Template (2)" but thinking ahead some people may forget to hit the command button and start entering into the original template. I tried to just lock the sheet but then the lock carries over to the copied template. My current code is: Sub NewForm() Sheets("Template").Select Sheets("Template").Copy After:=Sheets(1) End Sub Could I add some code at the end to tell the copy to unprotect? Thanks!! Stacey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
how to send documents from document imaging to word? | Excel Discussion (Misc queries) | |||
Excel should not delete document after trying to send email | Excel Discussion (Misc queries) | |||
Need TEMPLATE for Document Management | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel |