Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro/Command Button
Excel 2000 (or 97)
Although it's been a while, I have done this, but I cannot get it work now. I created a macro by using the macro recorder. I gave it the name Release. I then created a command button on the worksheet. The name of button is btnRelease. In design view, I selected the button and clicked ViewCode. That gave me the click event: Private Sub btnRelease_Click(). Between that and End Sub, I wrote "Release" (no quotation marks). I thought that would reference the macro and run it. I get the message "Function or interface marked as restriced, or function uses Automation type not supported in Visual Basic. Am I missing a step? I'll appreciate the help, -- Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
Run a macro using a command button | Excel Discussion (Misc queries) | |||
Run Macro from Command Button | Excel Discussion (Misc queries) | |||
Command Button & Macro | Excel Programming | |||
Macro for command button | Excel Programming |