vba - Hide Parent Page Hyperlink Excel -
I would like to hide the existing page that users are seeing when clicking on the hyperlink on the appiler, which gives them a single workbook I tried to use the following code within a different worksheet:
Personal sub worksheet_folic hyperlink (target bypass as hyperlink) error on GoTo Cleanup ActiveSheet. Visible = False Application.EnableEvents = False Target.Follow Cleanup: Application.EnableEvents = True End sub
Because I assume that the active sheet will be the sheet, which is the hyperlink on and the target Sheet is not on, however, any suggestions about hiding the pennette net sheet is the ActiveHeet target sheet?
It looks strange, but you
ActiveSheet.Visible Replace with False
Target.Parent.Parent.Visible = False
Why ?
- "target" is linked to the cell.
- / Html>
Comments
Post a Comment