I don't understand. This is the macro that would be assigned to any button from
the forms toolbar on any worksheet.

It'll clear the contents of the specified range when the user clicks on that
button.

Finance Guru wrote:

Hello Dave - Thanks for that,but what I really want is the button within the
worksheet,as the user(s) will not always know how to run a macro,hence the
requirement for the button to allow the user to click on,and let the macro
behind it do all the work.

"Dave Peterson" wrote:

You can write your code so that you're only using the active sheet.

Option Explicit
Sub testme()
with activesheet
msgbox .name 'just to verify
.range("b9,c22,e3:g9,h:h,w:x").clearcontents
end with
end sub

Finance Guru wrote:

Hello people,

How can i put a button into my worsheet,and attach a macro to it. so that
the button is only relevant to that w/sheet. I know how to drag a button on
the Toolbar from the Forms toolbar and attach a macro,but the same process
doesn't appear to work for my problem.

What I actually want to do is press this button which will then clear down
designated cells prior to use.

I am using Excel 2004

All offers of help gratefully accepted
FG

--

Dave Peterson


--

Dave Peterson