I am sure there is some way of doing this, but the "Help" feature has the
solution pretty well hidden . . .
I am trying to create a spreadsheet with a button control that will "show
all" lines once the user has finished using a line selected by using a
filter.
I know how to add a button, I know how to record a macro, I just can't
figure out how to run the macro when the button control is clicked. Any
Help?
Thanks,
Dick Prenovost

Hi

When you add a button from Forms toolbar into worksheet, you are asked for
assigning the macro attached to this button.


--
(When sending e-mail, use address (E-Mail Removed))
Arvi Laanemets


"Dick Prenovost" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am sure there is some way of doing this, but the "Help" feature has the
> solution pretty well hidden . . .
> I am trying to create a spreadsheet with a button control that will "show
> all" lines once the user has finished using a line selected by using a
> filter.
> I know how to add a button, I know how to record a macro, I just can't
> figure out how to run the macro when the button control is clicked. Any
> Help?
> Thanks,
> Dick Prenovost
>
>

If you have created the macro and placed the button on the sheet you
should be able to assign a macro by right clicking the button and use
'Assign a Macro' from the drop down menu.

Hope this helps

Mike


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/