ActiveX Command Button Inactive in Second Window

Matanuska · Mar 4th, 2002, 07:15 AM

I have an ActiveX command button on a worksheet that works fine until I use New Window to create a second window into the same worksheet. The button won't work there, just in the first window. Why is this & how do I fix it?

Matanuska · Mar 5th, 2002, 12:10 PM

I'm adding a bit of clarification in hopes someone can help me out.

The problem is very easy to duplicate:

1) Open a new blank worksheet

2) Display the Visual Basic toolbar & push the Control Toolbox button to display the Toolbox

3) Click the Command Button icon and draw a button on the worksheet, then push the Exit Design mode button

4) Click the button with the mouse & observe that it depresses & highlights correctly

5) Open a new window into the worksheet using the Window/New Window menu command

6) Press the button in the new window - it won't depress or highlight correctly, but it still works correctly in the original window. Anyone know why or how to fix this?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 07:15 AM	#1
Matanuska New Member Join Date: Feb 2002 Location: Houston, Texas Posts: 28	I have an ActiveX command button on a worksheet that works fine until I use New Window to create a second window into the same worksheet. The button won't work there, just in the first window. Why is this & how do I fix it?

Mar 5th, 2002, 12:10 PM	#2
Matanuska New Member Join Date: Feb 2002 Location: Houston, Texas Posts: 28	I'm adding a bit of clarification in hopes someone can help me out. The problem is very easy to duplicate: 1) Open a new blank worksheet 2) Display the Visual Basic toolbar & push the Control Toolbox button to display the Toolbox 3) Click the Command Button icon and draw a button on the worksheet, then push the Exit Design mode button 4) Click the button with the mouse & observe that it depresses & highlights correctly 5) Open a new window into the worksheet using the Window/New Window menu command 6) Press the button in the new window - it won't depress or highlight correctly, but it still works correctly in the original window. Anyone know why or how to fix this?