can not restor FormulaBar when i close yhe file

[rafik]

when i run the folowing code separatly it works but when i run it on close
file it does not,
please help
With Application
.ShowStartupDialog = True
.DisplayFormulaBar = True
.DisplayStatusBar = True
End With

 

[Tom Ogilvy]

Are you sure it runs?

 

[rafik]

yes

first
on open file i hide all CommandBars

on close file i run a macro to restor all the CommandBars
when it run it restor all of them exept for
StartupDialogis it because to activate them tou have to go to
Tool menu , Option?

 

[Tom Ogilvy]

No. Those are the commands to the best of my knowledge. If they work if run
manually, I would expect them to work in the BeforeClose event.