Forms - VB Editor Title Bar reference
Excel 2003
Hi,
Firstly, I hope that this thread is positioned in the correct forum...
I inherited a large excel workbook that was prone to 'crashing' but after some recent TLC, I have (hopefully) corrected this (having significantly reducing the size helped!!).
I have one concern though. Within the Visual Basic Editor, the 'title bar' usually displays the following format for its objects for some forms, ALL sheets and ALL modules.
For example:
Microsoft Visual Basic - MyWorkbook.xls - [Sheet1 (Code)]
Microsoft Visual Basic - MyWorkbook.xls - [frmMyForm1 (UserForm)]
Microsoft Visual Basic - MyWorkbook.xls - [modMyModule1 (Code)]
However, other forms appear to reference the workbook twice:
Microsoft Visual Basic - MyWorkbook.xls - [MyWorkbook.xls - frmMyForm2 (UserForm)]
Why does this happen? could it have happened when it crashed? and is it a problem?
Hope this makes sense.
Thanks in advance,
__________________
Neal
A Northern Soul
|