how to select a cell with a folder name when clicked opens t

[colleen]

I have several folders each containing several excel files..Now what I want to do is put the name of the folder in a worksheet..so that when I click it, it opens that folder..help appreciated,,

 

[Roccofan]

Hi Colleen,

Try using the hyperlink function. Ctrl + K or Insert > Hyperlink

This will allow you to link to a new worksheet, workbook, or open a folder for workbook selection.

RF

 

[colleen]

thanks that's pretty cool way ..