File in use notification

[Guest]

I have a file that several users access and I want to disable the file in use
notification when the file is opened by the second or subsequent users.

I can't find the way of doing it though .. any ideas ?

 

[Jim Rech]

The only way to avoid the in use message is to open the file read-only,
either manually or with a macro. It is generally thought important for
users to be notified that they cannot save changes to the file.

--
Jim
|I have a file that several users access and I want to disable the file in
use
| notification when the file is opened by the second or subsequent users.
|
| I can't find the way of doing it though .. any ideas ?

 

[Guest]

One other option is to make the workbook a shared workbook by going to
Tools->Share Workbook. Then check the "Allow changes by more than one user
at the same time" check box.

Note that shared workbooks have some limitations. Search the help for
"Features unavailable in shared workbook"

 

[Guest]

thanks .. that does what I want

One other option is to make the workbook a shared workbook by going to
Tools->Share Workbook. Then check the "Allow changes by more than one user
at the same time" check box.

Note that shared workbooks have some limitations. Search the help for
"Features unavailable in shared workbook"