View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rafik rafik is offline
external usenet poster
 
Posts: 6
Default 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