Force User to Enable Macros - Issue with activating specific sheet afterwards...

Originally Posted by Palmetto

I would use:

Application.Goto Reference:=Sheet1.Range("A1"), Scroll:=True

Change Sheet1 (code name for the sheet) to the applicable sheet in your workbook (whatever sheet = "Directory")

What is the proper placement of the code? Just above the setting of the macro sheet to hidden does not seem to work...