View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alok Alok is offline
external usenet poster
 
Posts: 318
Default Double Click for all Sheets

Hi,
Use Workbooks' Before double click event.
Alok

"Marvin" wrote:

I want to define an action for all sheets in my current workbook to occur
when I double click.

Is there a way that I can code the macro only once and sue it for all
worksheets, or must I define the macro for each sheet?

Thanks