Hi,
I am trying to write a spreadsheet in which the user will have to hyperlink to a reference file.
The people using this spreadsheet are not particularly good at excel, so I have put in a button to run a macro which opens the hyperlink dialog window in excel.
The problem I have is this window opens the file path of the current spreadsheet, but I want it to open up a level, is this possible?
Thanks very much,
Handles
I am trying to write a spreadsheet in which the user will have to hyperlink to a reference file.
The people using this spreadsheet are not particularly good at excel, so I have put in a button to run a macro which opens the hyperlink dialog window in excel.
The problem I have is this window opens the file path of the current spreadsheet, but I want it to open up a level, is this possible?
Thanks very much,
Handles