View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default What's causing this?

Karen

How are you opening the workbook(s)?

If from a shortcut, append /e to the command line to stop Book1 from opening.

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e

Note the <space before the /e

If opening by just double-click on a file................

Go to StartSettingsControl PanelFolder OptionsFile Types

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord Dibben MS Excel MVP

On Wed, 3 Jan 2007 08:52:00 -0800, Karen
wrote:

I have several macros in a workbook. I open excel (and Book 1 opens), then
the file w/ the macros; Book 1 stays open behind it and I believe it's
messing up the macros.

When I open the file from another computer this does not happen, however.
It seems like the macros are working ok on other computers. How can I
prevent book 1 from remaining in the background?