Copying "ThisWorkbook" objects

  • Thread starter Thread starter rpgun
  • Start date Start date
R

rpgun

Confused newbie question...

I have several tabs in a workbook. I want to copy only the "template
tab to a new workbook and have the new workbook reflect the sam
workbook attributes (code) as the old. Can I do this?

I really appreciate any help you could provide.

Thanks,
Bo
 
This will take the worksheet code across, but not code in a standard code
module

Sheets("Sheet1").Copy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
How to copy a workbook 8
ThisChart function similar to ThisWorkbook (XL2003) 4
Copying cells and formula from closed workbook to all sheets in open workbook 0
Save As and new workbook new name used in existing code 8
Code to 'unbundle' and array 1
Automation Error. What is this? 2
Copy code 4

Back
Top