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



Please Login or Register  to view this content.