can not restor FormulaBar when i close yhe file
 

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

can not restor FormulaBar when i close yhe file
 

Are you sure it runs?

--
Regards,
Tom Ogilvy


"rafik" wrote in message
...
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

can not restor FormulaBar when i close yhe file
 

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
StartupDialog
DisplayFormulaBar
DisplayStatusBar
is it because to activate them tou have to go to
Tool menu , Option?

"Tom Ogilvy" wrote:

Are you sure it runs?

--
Regards,
Tom Ogilvy


"rafik" wrote in message
...
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