Posted to microsoft.public.excel.programming

Ian[_17_]

external usenet poster

Posts: 11

Calling command button from another sheet

thanks for your help.
cheers

On Wed, 12 Apr 2006 09:16:02 -0700, Jim Thomlinson
wrote:

Assuming you have a button embeded in sheet1 (code name) called
CommandButton1...

goto to the code for the buttons and change it to Public...
Public Sub CommandButton1_Click()

Now in a sub in sheet 2 you should be able to reference the button using
Sub TestButtons
Call Sheet1.CommandButton1_Click
end sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create a command button to jump from sheet to sheet in a.	Darlenew	Excel Worksheet Functions	3	March 22nd 05 10:36 PM
Calling Com addin from form button on sheet?	Robin Hammond[_2_]	Excel Programming	8	January 8th 05 03:03 AM
Running a Command Button from a different sheet	Lester Lee	Excel Programming	5	July 14th 04 05:15 PM
Command Button slides when sheet is redrawn	Pubert	Excel Programming	0	April 16th 04 05:35 PM
Hiding A Sheet Command Button With VBA	Minitman[_3_]	Excel Programming	2	March 7th 04 01:16 AM

All times are GMT +1. The time now is 07:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us