View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Wall Bob Wall is offline
external usenet poster
 
Posts: 9
Default Double-click Event question

(Excel 97)
I am trying to code a print function, so that when a user double clicks on a
named range, certain rows of the worksheet are printed. No problem with the
printing aspect, but I'm having trouble getting the double click event to
work. I prefer to used named ranges instead of the value of the particular
cells to make it more generic, also so I don't have to change the code if
the cell value changes.

Thanks in advance!

BW