| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Run macro from clicking on a cell
Is there a way that you can run a macro from clicking on a specified cell with a hyperlink or function. I can use the shortcut key, but some 'here' say it is not user friendly to have to use a shortcut key. help files haven't helped. -Joe -- jrd269 ------------------------------------------------------------------------ jrd269's Profile: http://www.excelforum.com/member.php...o&userid=23815 View this thread: http://www.excelforum.com/showthread...hreadid=376404 |
|
#2
|
|||
|
|||
|
jrd269 wrote:
Is there a way that you can run a macro from clicking on a specified cell with a hyperlink or function. I can use the shortcut key, but some 'here' say it is not user friendly to have to use a shortcut key. help files haven't helped. -Joe ------------------- Generally I put a "button" control in a cell with a self-explanatory label and a link to the macro you want to run. Click on View/Toolbars and make sure "Forms" is checked. That will make a forms toolbar visible which allows you to create buttons, spinners, check boxes, etc. Good luck... Bill |
|
#3
|
|||
|
|||
|
sure thing, the button worked. You guys are great on this chat forum. Thank you, Joe -- jrd269 ------------------------------------------------------------------------ jrd269's Profile: http://www.excelforum.com/member.php...o&userid=23815 View this thread: http://www.excelforum.com/showthread...hreadid=376404 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A Macro that will cut and paste to specific cell | Excel Discussion (Misc queries) | |||
| Formula linked to cell with Macro | Excel Worksheet Functions | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
| Macro on cell content | New Users to Excel | |||
| Macro to sort by cell colour | Excel Worksheet Functions | |||
Linear Mode
