There is a legacy file with a protected sheet with buttons to run macros. Buttons when pressed execute the macros but I need to know which button execute which macros. Right clicking is not working as the sheet is protected neither enabling the design mode does. How to get this information? Any help will be greatly appreciated.

CodePudding user response：

Maybe start with somethingl ike this?

Dim ws As Worksheet, shp

For Each ws In ActiveWorkbook.Worksheets
    For Each shp In ws.Shapes
        Debug.Print ws.Name, shp.Name, shp.OnAction
    Next shp
Next ws