LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default 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
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
Use Macro To Change Which Macro Assigned To Command Button CVinje Excel Discussion (Misc queries) 0 May 25th 10 09:55 PM
Run a macro using a command button Tdahlman Excel Discussion (Misc queries) 9 March 5th 08 07:59 PM
Run Macro from Command Button [email protected] Excel Discussion (Misc queries) 1 April 23rd 07 04:36 PM
Command Button & Macro alexm999[_10_] Excel Programming 2 January 28th 04 09:12 PM
Macro for command button wcmar10 Excel Programming 0 July 30th 03 09:26 PM


All times are GMT +1. The time now is 04:56 PM.

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

About Us

"It's about Microsoft Excel"