Puzzling attribute - trying again
Normally that should not changed the Saved property (unless of course your
Personal is visible and active). Maybe the following will shed some light
Sub Test()
dim wb as Workbook
Set wb = Workbooks("personal.xlsb")
If wb.Saved = False Then
Debug.Print "hmm! reset Saved"
wb.Saved = True
End If
With ActiveWindow
.DisplayWorkbookTabs = Not .DisplayWorkbookTabs
End With
Debug.Print wb.Saved ' ?
Debug.Print ActiveWindow.Parent.Name ' ?
End Sub
Regards,
Peter T
"Bony Pony" wrote in message
...
Hi all,
Does anyone know why the command
ActiveWindow.DisplayWorkbookTabs = True or
ActiveWindow.DisplayWorkbookTabs = False
anywhere in an activeworkbook kicks off the prompt to save a hidden (and
untouched) Personal.xlsb when Excel is closed?
Kind regards,
Bony
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."
|