Executing Code When Cell Is Double Clicked.
 

I have a spreadsheet with a list of file paths and would like to be able to
click on one of the paths and have it open the file.
The files are outlook .pst files and I have the basic logic for opening them
in Outlook. I just need a way to trigger the code when a user double clicks
a field with a path in it.

Any suggestions? Things to look at that might lead me in the right
direction?

Thanks

Steve

Executing Code When Cell Is Double Clicked.
 

Use the beforedoubleclick event for the worksheet. In the event code, call
your macro to perform the action.

See Chip Pearson's page on Events for an overview
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Stever" wrote:

I have a spreadsheet with a list of file paths and would like to be able to
click on one of the paths and have it open the file.
The files are outlook .pst files and I have the basic logic for opening them
in Outlook. I just need a way to trigger the code when a user double clicks
a field with a path in it.

Any suggestions? Things to look at that might lead me in the right
direction?

Thanks

Steve