ViewToolbarsControl toolbar
Add a button
rightclick button View code
Put macro name here

when you are on this sheet and click the button, macro executes.
You choice as to printing button with worksheet or not

"johncassell" wrote:


Hello, I am looking for a way to run a macro with the press of just one
button when in my sheet, is this possible?

The sheet I am using is protected as well which may make this more
difficult.

I would really appreciate any help on this.

Thanks

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=395292