Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Buttons and assigning code
I have written some code which copies certain sheets from my master
workbook into a new workbook. So far I have written the code that creates the workbook, copies the sheets accross, creates modules with in the workbook and write procedures to them and then saves. I want to add buttons to sheets in the new workbook and assign the code to those buttons. How do i do this? using the following code seems to set the button to try and run code from the master workbook. ActiveSheet.Shapes("Button1").Select Selection.OnAction = "cmdButton1" Any Ideas? Many thanks Vincent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning Macros to Toolbar buttons | Excel Discussion (Misc queries) | |||
Assigning Macros to Buttons | Excel Discussion (Misc queries) | |||
Assigning Macros to Buttons in Excel | Excel Worksheet Functions | |||
Assigning Macro's to control buttons. | Excel Programming | |||
assigning macros to several custom buttons | Excel Programming |