Automatically generate Code for a worksheet created by a macro

Hi,
This is my first post to this group, so here goes.

I have a macro that reads from an array and then creates a new tab for each item in the array, it then sets up a template on each of the newly created tabs.

My problem is that I want to add a very simple macro to each new tab as well.

Please Login or Register  to view this content.

I can do this manually but would really like to automate this portion as well as there could be 25 or more sheets created.

Is this even possible.

Please let me know if you need further clarification.

Thanks,
JT

Hello jthompson,

Welcome to the Forum!

I hope this reply isn't to late for you to use it. You can call the macro from the Workbook_SheetSelectionChange event in the VBA Module ThisWorkbook. Now you won't have to add the macro to each individual sheet.

Please Login or Register  to view this content.

How to Save a Workbook Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on any Worksheet's Name Tab
3. Left Click on View Code in the pop up menu.
4. Press ALT+F11 keys to open the Visual Basic Editor.
5. Press CTRL+R keys to shift the focus to the Project Explorer Window
6. Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
7. Press the Enter key to move the cursor to the Code Window
8. Paste the macro code using CTRL+V
9. Save the macro in your Workbook using CTRL+S

Sincerely,
Leith Ross

Putting it at the workbook level TOTALLY fixed the problem.

Thanks!!!