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 ?

  1. "target" is linked to the cell.
  2. / Html>

Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -