The Takefocusonclick property is set to false. Activecell.activate didn't
correct it. But, thanks for the response.
"Dave Peterson" wrote:
If it breaks in xl97, try adding:
activecell.activate
at the top of the code.
Or you can change the .Takefocusonclick to false for that commandbutton.
Howard wrote:
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
--
Dave Peterson