| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book | Excel Programming | |||
| update message | Excel Discussion (Misc queries) | |||
| update prompt message | Excel Programming | |||
| message "Warning: Open source to update values..." | Links and Linking in Excel | |||
| Open up workbook but dont update links | Excel Programming | |||
Linear Mode
