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? |
All times are GMT +1. The time now is 03:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com