maxhayden
05-26-2009, 08:30 AM
Hi there, - I have 2 questions
1. Could anyone tell me how to copy and paste a template worksheet within a workbook and name it using VBA?
2. Is it possible to hide a worksheet (the template used for the new copies) within the workbook so users can't use or edit it?)
Here is the Logic:
1. Copy WorkSheet A
2. Paste NewCopySheet After (SheetCount)
3. ReName NewCopySheet "Link x" (x = 1 for first sheet, x = 2 for 2nd sheet ...)
Thanks in advance for your help!:bow:
1. Could anyone tell me how to copy and paste a template worksheet within a workbook and name it using VBA?
2. Is it possible to hide a worksheet (the template used for the new copies) within the workbook so users can't use or edit it?)
Here is the Logic:
1. Copy WorkSheet A
2. Paste NewCopySheet After (SheetCount)
3. ReName NewCopySheet "Link x" (x = 1 for first sheet, x = 2 for 2nd sheet ...)
Thanks in advance for your help!:bow: