I'm developing a workbook with two userforms. I have set them up with keyboard shortcuts using Tools/Macro/Macros
Until recently it worked fine: I open the workbook, enable macros, and open the two forms with Ctrl+Q and Ctrl+L
Recently, the shortcuts don't work reliably. Typically, on startup Ctrl+Q does nothing, but Ctrl+L works, but after opening the second form with Ctrl+L, the first one then opens fine with Ctrl+Q.
Looking at Tools/Macro/Macros immediately after opening the workbook, the two entries have different forms: the one that works OK is shown as ThisWorkbook.ShowLabelsForm, and the other one is shown as BCS_MemData!ShowDataForm
After using Ctrl+L to open LabelsForm, the entry for the Data form mysteriously changes to ThisWorkbook.ShowDataForm
Here is the code in the Workbook:
What's going on and how can I ensure that both forms are available on startup? Any help will be much appreciated. I'm using Excel2000 on WinXP and on Vista.
David
Bookmarks