can not restor FormulaBar when i close yhe file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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.
 
Back
Top