Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default "Ghost" workbook attached to my good workbook

Somehow I have gotten a "Book 1" workbook attached to a budget workbook.
When I bring up the live budget workbook, this Book 1 appears as well and I
can't get rid of it. I can "hide" it, but it doesn't stay hidden. I'd like
to just eliminate it altogether. The budget file is just too extensive for
me to copy it into another file and eliminate the original. Any ideas?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default "Ghost" workbook attached to my good workbook

One possible cause is that there is a VBA Reference from you Budget workbook
to the Book1 workbook. Press ALT F11 to open the VBA Editor, find your
workbook in the Project Explorer window on the left of the screen (CTRL R to
display the window if necessary), click the '+' symbol to expand it, and see
if there is a folder icon named 'References'. You can go to the Tools menu,
choose References, and uncheck any unnecessary references.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Teresa, CFP" <Teresa, wrote in message
...
Somehow I have gotten a "Book 1" workbook attached to a budget workbook.
When I bring up the live budget workbook, this Book 1 appears as well and
I
can't get rid of it. I can "hide" it, but it doesn't stay hidden. I'd
like
to just eliminate it altogether. The budget file is just too extensive
for
me to copy it into another file and eliminate the original. Any ideas?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to display "Good Morning" or "Good Evening" based on NOW() Wesley Excel Worksheet Functions 7 April 24th 23 11:45 AM
workbook "a" disappears on closing workbook "b" [email protected] Excel Discussion (Misc queries) 2 February 16th 07 09:12 AM
cannot use "Create List" and "Share Workbook" same time Devendra Excel Discussion (Misc queries) 0 October 26th 06 06:05 AM
How do I get Ghost Letters to show up "behind" my document? jjohnsonash Excel Discussion (Misc queries) 2 October 9th 06 07:41 PM
create links to check boxes marked "good" fair"and "bad" pjb Excel Worksheet Functions 3 April 20th 06 02:17 AM


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"