Convert Simple Excel 4.0 Macro to VBA

Marko

I suggest you don't try to convert that code to VBA but use a simpler method (which will still allow you to force users to run the file with your other VBA macros enabled).

In the attached files, I've removed the (Excel 4.0) Macros sheet and made a couple of examples of using Excel's Hyperlink function- click in either of the orange cells "Braves" or "Braves Away") on sheet Games and you'll jump to those places in sheet MLB.

This is how I did those two examples in the Games sheet:

Firstly I realised that your Excel 4.0 code seemed to be linked to transparent shapes above cells like F2. I right clicked to select one, then used Ctrl+A to select all and Delete to remove them.

Cell F2 has formula:

=Start!B1

so shows "Braves". Others do likewise.

I right-clicked F2 then clicked Link at the bottom of the sub-menu.

On the left hand side of the resultant Insert Hyperlink requestor, under "Link to:", I clicked "Place in This Document".  Then in "Type the cell reference", I pasted:

MLB!DZ13

(meaning cell DZ13 in sheet MLB) then clicked OK.

That put the link in F2 but the unfortunately default hyperlinks are blue (so very hard to see against a blue fill!). I set the font to white (and the fill to orange, just for illustration). You could also choose to remove the underline from the hypelink (as you would with regular text) but most people are accustomed to seeing underscored hyperlinks.

For cell T2 ("Braves Away"), the hyperlink formula is just

MLB!EW13

and I could use the Format Painter to copy the font colour/ fill from cell F2.

This seems to work well but your task would be to add similar hyperlinks, as above (and changing the address in MLB to suit).

Hope this fixes things for you. If so, please remember to mark this Answer as Selected.