Paul,

You need to put it on the toolbar, and assign a macro. To make it generally
available, I suggest you add to the Personal.xls file.

The macro should work on the activeworkbook and activesheet.

One for the code tips?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"pauluk " wrote in message
...
Hello,

Can some one please direct me or explain how i can create a button
which runs a macro. I create a button whichs runs a macro on a
workbook. But what i want is to creat a button which contains the macro
which then run on any sheet which is open.

Is this possible if so how do i do it?


---
Message posted from http://www.ExcelForum.com/