Allow Pivot Table Drill Sheets with Protected Workbook and Add Macro Button to Each Sheet

[chparkervatech]

I have a workbook and the below code that allows a pivot table to drill and open new sheets with protected "SNOW" sheet and workbook. I want to add a macro button to any new sheet created through the Pivot Table that allows the user to navigate back to the pivot table since I have removed the tabs from workbook. The loading and protecting works fine. I made an attempt below for the button and added to "SNOW" sheet and receive error. Please help.

"SNOW" Sheet

Please Login or Register  to view this content.

Workbook

Please Login or Register  to view this content.

Button

Please Login or Register  to view this content.

[XLent]

could you not just add a hyperlink, e.g. ?

Please Login or Register  to view this content.

modify the Hyperlink subaddress to appropriate location for the Pivot {given the DoubleClick is @Sheet rather than @Workbook level we presume a fixed target at all times - i.e. no need to cache the pivot tab name in a Global variable etc}