Hi,

I have a spreadsheet with file name Transmittal Log which I store in
shared drive or we commonly call it P:drive in our office.

1. I want to share this log sheet to all users so that every users can use
and log. How?

2. I want that when other user updates and use the a certain cell, like
another user is updating the log using Cell D6, a message box will pop up
telling other user to use other for someone is using it. Here is a sample
format of my log

A B C D
No. Transmittal to Transmittal No Description
1 ABC-Subcon A-001 Drawings
2 ABC-Subcon A-002 Drawings
3 ABC-Subcon A-003 Eng'g Design
4 ABC-Subcon A-004 60% Review Drawings
5 ABC-Subcon A-005 Construction Contract
6 ABC-Subcon A-006 let say other user is using this
cell (msgbox pop up) telling other user to use Cell D7
7 ABC-Subcon A-006

thanks i appreciate for any help

Hi Denver

For your first question:

Go to Tools - Share Workbook and on the Editing tab check the "Allow
changes by more than one user..." box.

Be aware that there is quite a list of features that are not available to
shared workbooks (see Excel help for a full list), but simple inputting
should not be a problem.

As for the second question: sorry, but that is beyond my limited expertise!

Anyway, hope this helps.


"Denver" wrote:

Hi,

I have a spreadsheet with file name Transmittal Log which I store in
shared drive or we commonly call it P:drive in our office.

1. I want to share this log sheet to all users so that every users can use
and log. How?

2. I want that when other user updates and use the a certain cell, like
another user is updating the log using Cell D6, a message box will pop up
telling other user to use other for someone is using it. Here is a sample
format of my log

A B C D
No. Transmittal to Transmittal No Description
1 ABC-Subcon A-001 Drawings
2 ABC-Subcon A-002 Drawings
3 ABC-Subcon A-003 Eng'g Design
4 ABC-Subcon A-004 60% Review Drawings
5 ABC-Subcon A-005 Construction Contract
6 ABC-Subcon A-006 let say other user is using this
cell (msgbox pop up) telling other user to use Cell D7
7 ABC-Subcon A-006

thanks i appreciate for any help