Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a macro to all new workbooks
I have a master workbook that creates other workbooks via VBA. Each new
workbook has a forms toolbar button. I have assigned a macro to the button using Set btn = ActiveSheet.Buttons.aDD(460, 1, 100, 25) btn.OnAction = "AddInterface" btn.Characters.Text = "Add Interface" This seems to reference back to the macro on the sheet that is creating the workbook. I would like each new workbook to contain a module with the VBA code I have written, called "AddInterface", that does not require the master sheet. Any ideas?? Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a macro to all new workbooks
Create a template with that code, and when adding workbooks, use the
template Workbooks.Add template_path_and_name -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "AndrewArmstrong" wrote in message ups.com... I have a master workbook that creates other workbooks via VBA. Each new workbook has a forms toolbar button. I have assigned a macro to the button using Set btn = ActiveSheet.Buttons.aDD(460, 1, 100, 25) btn.OnAction = "AddInterface" btn.Characters.Text = "Add Interface" This seems to reference back to the macro on the sheet that is creating the workbook. I would like each new workbook to contain a module with the VBA code I have written, called "AddInterface", that does not require the master sheet. Any ideas?? Thanks in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a macro to all new workbooks
Thanks Bob! I'll give it a shot and let you know how it turns out. I
really appreciate the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding data from different workbooks | Excel Worksheet Functions | |||
Adding Cells in two different Workbooks | Excel Programming | |||
Adding multiple workbooks together | Excel Discussion (Misc queries) | |||
Adding a row in all workbooks within a spreadsheet | Excel Discussion (Misc queries) | |||
adding a module to several different workbooks | Excel Programming |