| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel files not opening when double clicked | Excel Discussion (Misc queries) | |||
| Formula not displaying colored border when double clicked | Excel Discussion (Misc queries) | |||
| UserForms and double-clicked worksheets... | Excel Programming | |||
| Change cell value when right-clicked/double-clicked | Excel Programming | |||
| VB6, How do i open (instead of edit) an excel OLE doc when it is double clicked? | Excel Programming | |||
Hybrid Mode
