Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to display "Good Morning" or "Good Evening" based on NOW() | Excel Worksheet Functions | |||
workbook "a" disappears on closing workbook "b" | Excel Discussion (Misc queries) | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
How do I get Ghost Letters to show up "behind" my document? | Excel Discussion (Misc queries) | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |