Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |