Is there a way to make a filename a hyperlink or link within a text box?
My current code (below) just copies the workbook name.
Is there a way so that someone could click on the filename in the text box and it would go to that location.
I.e file is in c:\local\a.xls, this location shown the textbox1, by someone clicking on this it goes to this location in say explorer or opens the worksheet??
Private Sub UserForm_Initialize()
Set wb = ActiveWorkbook
TextBox1.Text = wb.FullName