| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Everytime i close an excel file, it creates a new backup file | Excel Discussion (Misc queries) | |||
| Hide Formula in Formulabar | Excel Discussion (Misc queries) | |||
| VBA - on a button event, open another closed file, post changes, close file | Excel Programming | |||
| display statusbar, scrollbars and formulabar | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Linear Mode
