Insert a new workbook with VBA code in the sheet module into existing macro

**bobaftt** · 02-18-2009, 03:37 PM

I am trying to figure out how I can insert a new sheet that includes some code that exists in a tab of my current sheet. I have some code that will make each row a specific color based on what is input by the comments column. I want to maintain this functionality in a new sheet where I will copy and paste the data. I have no idea how to do this! I have looked quite a bit online and in the books that I have but I am stumped.

**VBA Noob** · 02-18-2009, 04:24 PM

Maybe you could use a

Please Login or Register  to view this content.

using a select case or if statement to only run on sheets with similar names. Code would go in ThisWorkbook module

Also this link may be of interest
http://www.cpearson.com/excel/vbe.aspx

VBA Noob

**royUK** · 02-19-2009, 03:25 AM

Either keep a hidden sheet as a template or copy the existing sheet & delete unneeded data.

**bobaftt** · 02-19-2009, 10:04 AM

How do I copy the existing sheet? Assuming that I copy the entire existing sheet will that bring over the code as well?

**royUK** · 02-19-2009, 10:11 AM

This is the basic code to copy a sheet to the end of existing sheets

Please Login or Register  to view this content.

**bobaftt** · 02-19-2009, 12:12 PM

I think I am using the wrong term. I need to open a new workbook and insert the code rather then inserting a new sheet. And then I need some code inserted into the new workbooks sheet module.