Mouse Control

  • Thread starter Thread starter sparx
  • Start date Start date
S

sparx

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 Merge Data 2
macro to control tabs (different worksheets) 8
To disable pressing of Enter key on a sheet 1
Need Macro... 8
How to call module function or sub from the Add In? 3
VBA set thick borders around non empty cells in range 0
Automatic Activation of Macro when Tabbing into a cell 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top