hey...

okay.. almost done with this workbook.

ive been able to get alot of help through this discusions.. thanx every1

one more thing...

ive got this code in my workbook open thingie

Select Case Sheets("data").Range("A111").Value
Case "a"
Application.Run "editINVENTRY.xls!download.download"
End Select


and to get the "a" i use this in the worksheet code

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("data").Range("A111").Value = "A"
End Sub

this all are working good and briljant.. THANX TO ALL THAT HELPED!!!!

but now when the authorised user make changes to the sheet and get the "A"
like needed and then mail to the other users. they then open it and the
download macro update their inventry.

where and what code would i use to get the "editINVENTRY.xls" to not run on
the authorised users computer? in other words when she go in again to change
anything els the "a" is still there

all the users in our company are born BC (before computers) so to tell her
to hit escape and del the a and then edit what needed be would not work..

thanx again every1

Phillip