Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Microsoft's website says the following: "This behavior can occur if the
references to the button are no longer valid because the menu context has been switched to another document. " I would make sure to also check the reference to the form. Do you have more than one workbook open? Has the file name changed and affected the reference? I really don't know what else to suggest other than double checking the entries. In design mode, double-click the button to make sure that it is referencing the right code. Also, I couldn't tell from before, but make sure that the following code is in a separate module and not the code for the sheet (you may have already done this) Sub OpenInputForm() frmTrendScoreCard.Show End Sub I hope that helps. I've tried to recreate what you're saying and haven't been able to at all. Never seen this before... "PokerZan" wrote: When I click on the definition as JNW suggested it pulls up the code behind my form... if that helps with anything. -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=477310 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you make a userform open automatically when you open excel? | Excel Worksheet Functions | |||
Load caption box on userform open | Excel Worksheet Functions | |||
Add a button to a sheet to open a userform | Excel Discussion (Misc queries) | |||
How do I Open A UserForm in a Worksheet | Excel Programming | |||
Click on worksheet with UserForm open? | Excel Programming |