Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to skip the save file notoification on file closing? | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
HTML Help not closing the file | Excel Discussion (Misc queries) | |||
VBA Closing File | Excel Programming | |||
VBA closing one file | Excel Programming |