Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
| Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 24th, 2009, 05:29 AM
Friend of Wrox
Points: 718, Level: 10
Points: 718, Level: 10 Points: 718, Level: 10 Points: 718, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: Ennis, Clare, Ireland.
Posts: 131
Thanks: 10
Thanked 0 Times in 0 Posts
Default 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




Similar Threads
Thread Thread Starter Forum Replies Last Post
create custom vb form title bar cindy Pro VB 6 1 September 22nd, 2005 02:57 PM
url appears in title bar when refreshing shibp2pkumar Classic ASP Basics 3 May 4th, 2005 07:48 PM
How to trap Mouse events on Title bar/Caption bar chiefouko Pro VB.NET 2002/2003 0 September 21st, 2004 02:42 AM
Dynamically write to title bar. fs22 Javascript How-To 2 June 2nd, 2004 04:16 PM
Removing title bar - is this possible? larry HTML Code Clinic 4 January 26th, 2004 03:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.