Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Do you want to save the changes you made to€¦vbYesNoCancel"
during Access-to-Excel automation. I'd read that can be prevented by... Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Saved = True End Sub However, I'm using FollowHyperLink w/ the option to open the Excel File... In using.. Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Saved = True End Sub ...it doesn't allow the FollowHyperlink in code to open the file..a "Gotcha"...how can I avoid the "..want to save the changes you made.." MsgBox and STILL open the file w/ FollowHyperlink??? TIA - Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Result = Volatile ?? | Excel Discussion (Misc queries) | |||
Text Causing a Problem in Formula | Excel Discussion (Misc queries) | |||
formula result=Volatile | Excel Discussion (Misc queries) | |||
VLOOKUP Formula causing an error | Excel Discussion (Misc queries) | |||
Formula Causing a Save Error Message | Excel Worksheet Functions |