this code will not work in my spreadsheet... trying to hyperlink to a hidden sheet. The error is on the 3rd line. I believe the shtname does not have a value. I have the VB in the worksheet under follow hyperlink. What am I missing?
dim shtname as string
shtname=target.name
sheets(shtname).visible=xlsheetvisible
sheets(shtname).select
dim shtname as string
shtname=target.name
sheets(shtname).visible=xlsheetvisible
sheets(shtname).select