On new window trigger

**Dessy277** · 06-13-2022, 04:25 AM

Hi Everyone,

Hoping someone might be able to point me in the right direction, what I am trying to do is have a macro run when someone clicks the "New Window" button within the view tab.

I have a separate bit of code that creates the new window and runs the code, however I really want to ensure the user doesn't press the button and bypass the code I am hoping to run.

Many thanks,

Matt

**rorya** · 06-13-2022, 04:29 AM

You can do that by intercepting or disabling the New Window button in the CustomUI part of your workbook. So you'd use something like:

PHP Code:


< command idMso="WindowNew" enabled=False</command>

**cytop** · 06-13-2022, 04:47 AM

... intercept, and repurpose it to run your existing procedure to open a new window.

Either way, you'll be editing the ribbon XML which is a whole new world of pain. Example below displays a message box when the New Window button is clicked..