Hi All,
I'm having an issue with hyperlink creation, currently commented out in my VBA.
I've tried to sort it myself for about 3 weeks, read endless posts but i'm simply missing something.
INFO:
Sheet1 (ORDERS) A:A list of order numbers
Sheet15 (ORDER_INFO) Pre-Formated sheet to duplicate and rename.
The idea behind my VBA is you double click an Order Number and a sheet is duplicated and renamed to the Order Number. It is also hidden.
The original Order Number that was double clicked is then made into a hyperlink, this should unhides the new sheet and then go to it.
The duplicated sheet already has code to hide when deactivated
If you can shed some light into where I am going wrong I would be very appreciative.
Cheers
Bookmarks