Hi All,
I'm After some help writing some code to complete the following.
So if you press CTRL + Right Click on any cell in Column A it will bring up a user form which has 3 buttons. "Open Folder" "Open Latest Drawings" "Cancel". I'm wanting each button to go to a location on our server based on which button is pressed.
1. To go to project folder it will have to look at SERVER\Company (Column C) \Project No (Column A) & Project Name (Column B). this will then open that folder location
3. Unload User form.
Would anyone be able to help or have done something similar that i could maybe try and edit? I have included my workbook with the two columns highlighted and the user form already created for your assistance.
Cheers
ND
Bookmarks