I experimented with creating Macro's in Excel 2007. Now, everytime I open
Excel, Book1 opens, and remain open when I open another existing file. When I
close the existing opened file, Book1 is still open. I tried to hide it, but
then the 'frame' still remain open.

Before you start experimenting with macros, you need to be comfortable with
Excel. Everytime any version of Excel opens Book1 is displayed. This is the
default behavior of all versions of Excel.

In Excel opening a file does not close down other open files.

If you don't want to keep a file open, don't hide it just close it.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"DanieB" wrote:

I experimented with creating Macro's in Excel 2007. Now, everytime I open
Excel, Book1 opens, and remain open when I open another existing file. When I
close the existing opened file, Book1 is still open. I tried to hide it, but
then the 'frame' still remain open.

Hi Shane, Thank you for your response. Normally when I open Excel, Book1 is
opened. If I then select from my files, another workbook, it is opened as a
second workbook. (I can click between the two) When I close the second
workbook, Book1 is still open, and I must then manually close Book1 as well.
I recorded Macro's in 2003 version, but 2007 is slightly different and I did
something wrong when it asked me where do I want to save the Macro. The Macro
worked fine, but the Book1 staying open at all times then started. I deleted
the Macro, but no solution yet.

"Shane Devenshire" wrote:

Before you start experimenting with macros, you need to be comfortable with
Excel. Everytime any version of Excel opens Book1 is displayed. This is the
default behavior of all versions of Excel.

In Excel opening a file does not close down other open files.

If you don't want to keep a file open, don't hide it just close it.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"DanieB" wrote:

I experimented with creating Macro's in Excel 2007. Now, everytime I open
Excel, Book1 opens, and remain open when I open another existing file. When I
close the existing opened file, Book1 is still open. I tried to hide it, but
then the 'frame' still remain open.

Hello - the issue DanieB is seeing also is happening to me. I have some Excel add-ins installed, is that what's causing a Book 1 to open when I open existing spreadsheets? It's really annoying!!



DanieB wrote:

Hi Shane, Thank you for your response.
08-Sep-09

Hi Shane, Thank you for your response. Normally when I open Excel, Book1 is
opened. If I then select from my files, another workbook, it is opened as a
second workbook. (I can click between the two) When I close the second
workbook, Book1 is still open, and I must then manually close Book1 as well.
I recorded Macro's in 2003 version, but 2007 is slightly different and I did
something wrong when it asked me where do I want to save the Macro. The Macro
worked fine, but the Book1 staying open at all times then started. I deleted
the Macro, but no solution yet.

"Shane Devenshire" wrote:

Previous Posts In This Thread:

On Monday, September 07, 2009 9:34 AM
DanieB wrote:

Opening Excel 2007 Book1 problem
I experimented with creating Macro's in Excel 2007. Now, everytime I open
Excel, Book1 opens, and remain open when I open another existing file. When I
close the existing opened file, Book1 is still open. I tried to hide it, but
then the 'frame' still remain open.

On Monday, September 07, 2009 12:24 PM
Shane Devenshire wrote:

Before you start experimenting with macros, you need to be comfortable with
Before you start experimenting with macros, you need to be comfortable with
Excel. Everytime any version of Excel opens Book1 is displayed. This is the
default behavior of all versions of Excel.

In Excel opening a file does not close down other open files.

If you do not want to keep a file open, do not hide it just close it.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"DanieB" wrote:

On Tuesday, September 08, 2009 2:10 AM
DanieB wrote:

Hi Shane, Thank you for your response.
Hi Shane, Thank you for your response. Normally when I open Excel, Book1 is
opened. If I then select from my files, another workbook, it is opened as a
second workbook. (I can click between the two) When I close the second
workbook, Book1 is still open, and I must then manually close Book1 as well.
I recorded Macro's in 2003 version, but 2007 is slightly different and I did
something wrong when it asked me where do I want to save the Macro. The Macro
worked fine, but the Book1 staying open at all times then started. I deleted
the Macro, but no solution yet.

"Shane Devenshire" wrote:

EggHeadCafe - Software Developer Portal of Choice
WS-Security, SAML, Standards: Future of Webservice
http://www.eggheadcafe.com/tutorials...ml-standa.aspx