Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
buttons???
I've created a macro which creates a worksheet containing a button whic activates a second macro if selected. Everything is working well s far! However I want the first macro to return the button with the nam "update" - at present it returns a macro called button 2, button 3 et which then crashes the second macro. I can't find a way to do this? Can anyone help please ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
buttons???
Ali wrote:
However I want the first macro to return the button with the name "update" - at present it returns a macro called button 2, button 3 etc which then crashes the second macro. Assuming that this is a Forms toolbar button then With ActiveSheet.Buttons.Add(1, 2, 3, 4) .Name = "Update" .OnAction = "MyMacro" End With Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
Control Buttons vs. Command Buttons | Excel Programming |