Thread
:
Macro/Command Button
View Single Post
#
3
Posted to microsoft.public.excel.programming
Howard
external usenet poster
Posts: 40
Macro/Command Button
I just used the macro recorder to sort a work sheet on the date field. I gave
the macro a softcut key: Cntr-Shift-R. The macro works fine if I use the
short cut key. I thought I could just reference the macro by name (Release)
in the Click event of the command button to get it to run. Doesn't work.(?)
"Don Guillett" wrote:
As always, copy/paste your code for comments.
--
Don Guillett
SalesAid Software
"Howard" wrote in message
...
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
Reply With Quote
Howard
View Public Profile
Find all posts by Howard