LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 265
Default Chanagin buttons images

pd. appears a strange error:
Compile error
method or data member not found

"K Dales" wrote:

An easier way to set this up would be to create three different buttons (and
associated macros) and set them beside each other, then use the
CommandButton.Visible property to selectively make them appear and disappear;
to the user this would have the same functionality:

Sub MyButton1_Click()
' Put your code here
CommandBars("MyBar").CommandButtons("MyButton1").V isible = False
CommandBars("MyBar").CommandButtons("MyButton2").V isible = True
End Sub

Sub MyButton2_Click()
' Put your code here
CommandBars("MyBar").CommandButtons("MyButton2").V isible = False
CommandBars("MyBar").CommandButtons("MyButton3").V isible = True
End Sub

Sub MyButton3_Click()
' Put your code here
CommandBars("MyBar").CommandButtons("MyButton3").V isible = False
CommandBars("MyBar").CommandButtons("MyButton1").V isible = True
End Sub

"filo666" wrote:

Hi, I made a custom toolbar, I want when a user clicks one button appears an
image (and a macro is executed), when he presses again (the same button)
appears another button image and another macro is executed and finally when
he presss it again (the same button), execut another macro and the first
button image appears. How Could I do this???



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Chart.Export images are shrinking as I export more images Jared Charts and Charting in Excel 3 January 29th 08 03:23 AM
Form buttons vs. ActiveX Buttons GeorgeJ Excel Discussion (Misc queries) 3 August 11th 07 09:02 PM
have toggle buttons but everytime print preview buttons move TinSandhu Excel Discussion (Misc queries) 1 October 11th 06 02:57 PM
How to add images to custom toolbar buttons? RADO[_3_] Excel Programming 3 November 1st 03 05:07 PM
Control Buttons vs. Command Buttons Robert Gibson Excel Programming 1 October 13th 03 04:33 PM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"