LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default closing dummy file

Dear group,

A former discussion about how to delete the message on opening the file
(links to other worksheets) was great for my problem. Tom suggested to
create a dummy file, which opens the other file and which suppresses
the message. Here's the link:

dummy file: A
other file (with message to be suppressed): B

http://groups.google.com/group/micro...bc4642b707c7d7

Now, as I know my users, they will complain that there is another file
opened. How can I close that one again? It appears that in B Auto_Open
does not work anymore... so I had to include those lines also in A's
Auto_Open.

At which point shall I close A? After opening B (disabled Auto_Open in
B -- how can it be done automatically then?)? Or do you know a way to
close A when user closes B (automatically closing A).

Thanks for your help.

Best regards,

Rico

 
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
How to skip the save file notoification on file closing? Dan Excel Worksheet Functions 1 August 19th 07 02:26 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
HTML Help not closing the file pod Excel Discussion (Misc queries) 0 April 18th 05 04:45 PM
VBA Closing File John Viall[_2_] Excel Programming 3 April 7th 05 03:49 PM
VBA closing one file colic Excel Programming 2 September 25th 03 05:16 PM


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"