Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
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 November 29th, 2006, 04:50 PM
Authorized User
 
Join Date: Jun 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel File closes but project doesn't

When I close an excel file, the project is still present in the Vba

When I open the property box for this orphan project, and click on the workbook, the property box is completely blank - so part of vba knows that the workbook is not there but Project Explorer does not and closing/opening Project Explorer does not help

By repeating the process, I can get multiple instances of a project in vba. I have to close excel to get rid of the phantom project.

How do I fix excel so that projects close properly

Thanks,

Barry






Similar Threads
Thread Thread Starter Forum Replies Last Post
Invoice excel vb6 Project help alireza Excel VBA 1 November 18th, 2006 12:56 PM
error message then closes down dion Dreamweaver (all versions) 0 August 3rd, 2006 12:10 PM
Can't reference to range in excel project 2003 Nashja C# 3 March 8th, 2006 07:24 AM
Copy excel macros to vb project battlebob Excel VBA 2 November 9th, 2004 10:13 AM
Need a bit of help with an Excel project wwfc_barmy_army Excel VBA 1 November 1st, 2004 04:17 AM





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