Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Can anyone please give me a hand with this beginner question? I'm opening a workbook in a procedure and disabling the alert asking if I want to update links to other workbooks: Set wbBook = Workbooks.Open( MyFile, False, False) But then when I close the workbook at the end of the same procedure, I want to reactivate the alert. Else, when I open the workbook manually in Excel, a dialog box opens looking for the linked files for updating and I have to hit Cancel a few times to close the box. I want to have the alert appear again when I open the workbook manually. Thanks in advance, Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reset workbook back to Auto Calculate | Excel Discussion (Misc queries) | |||
alerts for changes in workbook | Excel Discussion (Misc queries) | |||
How reset margins in Excel workbook? | Excel Discussion (Misc queries) | |||
closing excel after closing a workbook | Excel Programming | |||
Closing a workbook with no alerts | Excel Programming |