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