| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro on a CommandButton from another sheet
I am trying to get a macro linked to a commandbutton to run, from another code in another sheet, but
casnnot get the code right. Tried: Sheet2.CommandButton2.Select etc to no avail What is the line of code to run it ? Corey.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run macro on a CommandButton from another sheet
Nevermind, just worked it out as i placed the post.
Removed the Private from the Commandbutton2 _Click Sub and when i typed in Sheet2. The Commandbutton2_Click was then listed. Yay! Corey.... "Corey" wrote in message ... I am trying to get a macro linked to a commandbutton to run, from another code in another sheet, but casnnot get the code right. Tried: Sheet2.CommandButton2.Select etc to no avail What is the line of code to run it ? Corey.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link a commandbutton in excel sheet to a VB userform? | Excel Programming | |||
| Calling sub from CommandButton knowing which sheet is active | Excel Programming | |||
| Save a copy of particular sheet minus VBA, CommandButton of parent workbook | Excel Programming | |||
| Adding commandbutton to sheet | Excel Programming | |||
| Macro won't run from CommandButton | Excel Programming | |||
Hybrid Mode
