| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mouse Control
I already have 3 worksheets each with a macro that you have to use a key stroke to run - how can I make them run by say having a cell with "press here" written in it to activate that worksheets macro by the mouse? -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=467252 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mouse Control
you can insert a text box (drawing toolbar) and assign a macro to the box. to get there right click onto the edge of the box size the text box to fit a cell and delete the borders if you like. -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=467252 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mouse Control
Thanks I will do tha -- spar ----------------------------------------------------------------------- sparx's Profile: http://www.excelforum.com/member.php...fo&userid=1678 View this thread: http://www.excelforum.com/showthread.php?threadid=46725 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mouse Control
Why not use a button?
"sparx" wrote: I already have 3 worksheets each with a macro that you have to use a key stroke to run - how can I make them run by say having a cell with "press here" written in it to activate that worksheets macro by the mouse? -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=467252 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mouse Control
why not use a button???........... Not sure, I've always used small pictures or text boxes and assigned the macro's to them. What is the advantage of using a button? At least with the pictures or textboxes you can "translate" the function of the macro into a picture. Open to suggestions and always willing to learn though Thanks -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=467252 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mouse control | Excel Worksheet Functions | |||
| control-tab should move between Excel sheets without a mouse. | Excel Worksheet Functions | |||
| my mouse moves diagonally when i scroll on mouse? | Excel Worksheet Functions | |||
| Mouse Wheel & Mouse Drivers | Excel Programming | |||
| moving mouse highlights cells without touching left mouse button | Excel Discussion (Misc queries) | |||
![sparx[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
