Use a keyboard button to run a macro
 

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

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

I would really appreciate any help on this.

Thanks

Joh

--
johncassel
-----------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...fo&userid=2501
View this thread: http://www.excelforum.com/showthread.php?threadid=39529

Use a keyboard button to run a macro
 

When you say "press of one button", do you mean to click on one butto
the sheet, a button on a toolbar <or to press one key on the keyboard
All are possible, but all require different steps.

More info, please.

Bruc

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=39529

Use a keyboard button to run a macro
 

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