Hi all,
i'm trying to create some code so if i double click on a cell ("Open_Project") i will open the project folder.

I have tried to create the code but i'm having trouble finishing it can anyone help at all?

Sub OpenProjectFolder()Shell explorer.exe,ProjectRootFolder & " \ " & CCompanyName & " \ " & JobNumber & " - " & CSiteName", vbNormalFocus
End Sub
Thanks ND