View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JAnderson JAnderson is offline
external usenet poster
 
Posts: 10
Default Double-click to run macro?

Greetings,

I'd like to create some code which would allow a user to double-click a cell
to run a macro. To make it easy, there's only 1 macro in the workbook and I
want the user to double-click cell A1.

I'm relatively new to VBA, and I'm having trouble figuring out at which
level I need to put this double-click code (in addition to how to make it in
the first place). Any suggestions? Thanks in advance!