Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running command button click event code
Hey is it possible to run a code in the click event of commandbutton10 on
workbook open? Thanks Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running command button click event code
Not sure if this is the best method, but an approach I have used is to
create separate procedures for the events that you want to run manually. Eg Sub Workbook_Open() Call SubRoutine1 End Sub Sub CommandButton10_Click() Call SubRoutine1 End sub Public Sub SubRoutine1() 'Common code in here which runs for workbook open and CommandButton10 End Sub Cheers N "Marishah Warren" wrote in message ... Hey is it possible to run a code in the click event of commandbutton10 on workbook open? Thanks Todd Huttenstine ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Command Button After Click | Excel Discussion (Misc queries) | |||
Command Button Click | Excel Discussion (Misc queries) | |||
Command button to toggle worksheet event code on / off? | Excel Discussion (Misc queries) | |||
On click button event | Excel Worksheet Functions | |||
specialcells and toolbox button click event | Excel Programming |