Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?


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
Password on VBA causing problem Ken Excel Programming 1 June 14th 06 04:26 AM
Rand () causing Problems. JCary Excel Discussion (Misc queries) 1 March 6th 06 10:38 PM
RefEdit causing crashes [email protected] Excel Programming 5 October 24th 04 01:35 PM
What is causing a #Value! Phillips Excel Programming 1 November 19th 03 08:47 PM
Excel causing Berny Excel Programming 1 August 14th 03 01:09 PM


All times are GMT +1. The time now is 03:34 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"