Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I determine the value of the OnAction property of an existing
(built-in or custom) commandbar item? I would like to do something like this: Public Sub ShowOnAction() MsgBox Application.CommandBars("File").Controls("Print Preview").OnAction End Sub This sub does not fail, but it returns nothing. I would also like to intercept the subroutine called by the OnAction property and replace it like in this Word procedu http://www.mvps.org/word/FAQs/Macros...tSavePrint.htm Can that be done in Excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I find out property values for each control object? | Excel Discussion (Misc queries) | |||
Passing several parameters to OnAction property. | Excel Discussion (Misc queries) | |||
DrawingObjects/AutoShapes' .OnAction property in DialogSheets | Excel Discussion (Misc queries) | |||
Capturing Shape Name/Text from OnAction property | Excel Discussion (Misc queries) | |||
Can Range.Find search a Cells' Text property? | Excel Programming |