Non responsive buttton in second window 1

[xwb]

I have an excel sheet with a button. When I click on the button, it responds. All well and good.

I then click New Window and tile vertically, I get two copies of the same spreadsheet side-by-side, both with the same button. If I try clicking on the button on the new window, it behaves like it has been disabled. If I click on the button on the original window, it responds.

Does anyone know why the second window is unresponsive? I tried looking it up on the internet but all I can find is lots of questions on excel not responding: not why one window responds and the second does not.

 

[SkipVought]

It depends how the control has been programmed. So what's the code behind the click event?

BTW, I was gonna say that the reason was, you had too many t's In your buttton, but I didn't want to tease you, unless you might want to choose between Earl Grey or Lipton.

 

[xwb]

Pu Er (one of the many Chinese teas). ha ha

The code behind the click event was to create a database from the spreadsheet data. As a little experiment, I made a mockup with just a message box saying that it worked. Same thing. I've only tried this on Office 2013. I haven't tried it on any of the earlier ones.

 

[SkipVought]

BTW, what kind of button? forms or ActiveX?

 

[SkipVought]

Seems a Forms button will work in both windows, but not an ActiveX.

Just curious: why the new window? what are you trying to accomplish?

 

[xwb]

New window - to look at two different worksheets while writing the VBA.

Yes - it was an ActiveX button. Changed it to a Forms button and it worked.