open message box before the update or dont update message box open
 

Tried posting this question before, didnt work. anyway, thanks for all your
past answers have leaned a great deal. I have a workbook that I dont want
people to update when they open it, so I am looking to set up a message box
to inform them not to update when asked. I have tried the open and the
workbook activate events but they still opened after the "Update/Don't
Update" box. Is there anyway to get the macaro to activate prior to that??
tks once again. J
--
Cheers!

open message box before the update or dont update message box open
 

Check out the UpdateLinks property in VBA help.

Private Sub Workbooks_Open()
ThisWorkbook.UpdateLinks xlUpdateLinksNever
End Sub




"Jay" wrote in message
...
Tried posting this question before, didnt work. anyway, thanks for all
your
past answers have leaned a great deal. I have a workbook that I dont want
people to update when they open it, so I am looking to set up a message
box
to inform them not to update when asked. I have tried the open and the
workbook activate events but they still opened after the "Update/Don't
Update" box. Is there anyway to get the macaro to activate prior to that??
tks once again. J
--
Cheers!

open message box before the update or dont update message box
 

Roger that, and thanks for the tip !!!! I love this Group !!!!
--
Cheers!


"JLGWhiz" wrote:

Check out the UpdateLinks property in VBA help.

Private Sub Workbooks_Open()
ThisWorkbook.UpdateLinks xlUpdateLinksNever
End Sub




"Jay" wrote in message
...
Tried posting this question before, didnt work. anyway, thanks for all
your
past answers have leaned a great deal. I have a workbook that I dont want
people to update when they open it, so I am looking to set up a message
box
to inform them not to update when asked. I have tried the open and the
workbook activate events but they still opened after the "Update/Don't
Update" box. Is there anyway to get the macaro to activate prior to that??
tks once again. J
--
Cheers!