VBA macro for hyperlink to active workbook in the active workbook path

I have two workbooks


workbook 1-master is a 20-worksheet account workbook that end users will copy into a new folder, naming the folder and workbook after account they are working.

workbook 2 is an organizing workbook that has a row dedicated to each account for which the user has a separate workbook (a renamed copy of the workbook 1)

I've included one worksheet in workbook 1 master with a row that needs to be copied into the organizer workbook. The row contains summary data for workbook 1 including two hyperlinks: 1 referencing the renamed workbook and the other referencing the folder in which the renamed workbook is stored. Right now the end use has to manually enter the hyperlinks into the row to be copied, because the specific address does not exist until after the workbook and folders are created. I spend way too much time helping people write their hyperlinks.

I would like to write hyperlink macros for workbook 1-master. The hyperlinks should reference the active workbook path and active workbook file name so that the end user can push a macro button AFTER they copy the master into their newly created folder with a new workbook name. I would install the button on the worksheet containing the row which needs to be copied into the Organizer workbook.

The hyperlink for the workbook will be in Cell H1 and the hyperlink for the folder will be in I1.

If I can get a bit of code to get started I can adapt it as needed. Any help is greatly appreciated!

The hyperlinks extend across network drives. When created directly they tend to produce a roaming error after a day or two and have to be reset.

Thanks, Charlie. I'm such a novice at VBA that I need it spelled out for me. I've never written a hyperlink and don't quite understand the syntax. Could you write me a sample based on the discussion above?....something I could copy into a module?

I've attached both workbooks for your convenience

Claims Organizer-master.xlsmWorkbook-Macro-edition-blank-.xlsm

Charlie, I forgot to tell you that the worksheet in the Master workbook is the "organizer" worksheet