Formula Bar Hidden
Hi
I have written a VBA code to hide formula bar in the Workbook open event. The code is : If Application.DisplayFormulaBar = True then Application.DisplayFormulaBar = False End if To bring the formula bar back once I exit out of this workbook, I wrote a code in workbook before close event and the code is If Application.DisplayFormulaBar = False then Application.DisplayFormulaBar = True End if I am able to hide the formula bar, but it never brings the formula bar visible for the application. Every time, after using this sheet, I have to manualy add the formula bar. Please advise, how can I correct this problem |
Formula Bar Hidden
Try deleting the If statement and just use:
Application.DisplayFormulaBar = True No error is generated if the Formula Bar is already displayed. "ub" wrote in message ... Hi I have written a VBA code to hide formula bar in the Workbook open event. The code is : If Application.DisplayFormulaBar = True then Application.DisplayFormulaBar = False End if To bring the formula bar back once I exit out of this workbook, I wrote a code in workbook before close event and the code is If Application.DisplayFormulaBar = False then Application.DisplayFormulaBar = True End if I am able to hide the formula bar, but it never brings the formula bar visible for the application. Every time, after using this sheet, I have to manualy add the formula bar. Please advise, how can I correct this problem |
Formula Bar Hidden
Hi
Thanks for the reply I tried with removing the if statement and it still does not work. Please advise "JLGWhiz" wrote: Try deleting the If statement and just use: Application.DisplayFormulaBar = True No error is generated if the Formula Bar is already displayed. "ub" wrote in message ... Hi I have written a VBA code to hide formula bar in the Workbook open event. The code is : If Application.DisplayFormulaBar = True then Application.DisplayFormulaBar = False End if To bring the formula bar back once I exit out of this workbook, I wrote a code in workbook before close event and the code is If Application.DisplayFormulaBar = False then Application.DisplayFormulaBar = True End if I am able to hide the formula bar, but it never brings the formula bar visible for the application. Every time, after using this sheet, I have to manualy add the formula bar. Please advise, how can I correct this problem |
Formula Bar Hidden
After thought. You will also need to save the workbook after you re-instate
the Formula Bar, otherwise it will open in the last saved state. "ub" wrote in message ... Hi I have written a VBA code to hide formula bar in the Workbook open event. The code is : If Application.DisplayFormulaBar = True then Application.DisplayFormulaBar = False End if To bring the formula bar back once I exit out of this workbook, I wrote a code in workbook before close event and the code is If Application.DisplayFormulaBar = False then Application.DisplayFormulaBar = True End if I am able to hide the formula bar, but it never brings the formula bar visible for the application. Every time, after using this sheet, I have to manualy add the formula bar. Please advise, how can I correct this problem |
Formula Bar Hidden
I added code
activeworkbook.save after the Application.DisplayFormulaBar = True statement. But it still does not work. Please advise, if I need to change the save statement "JLGWhiz" wrote: After thought. You will also need to save the workbook after you re-instate the Formula Bar, otherwise it will open in the last saved state. "ub" wrote in message ... Hi I have written a VBA code to hide formula bar in the Workbook open event. The code is : If Application.DisplayFormulaBar = True then Application.DisplayFormulaBar = False End if To bring the formula bar back once I exit out of this workbook, I wrote a code in workbook before close event and the code is If Application.DisplayFormulaBar = False then Application.DisplayFormulaBar = True End if I am able to hide the formula bar, but it never brings the formula bar visible for the application. Every time, after using this sheet, I have to manualy add the formula bar. Please advise, how can I correct this problem |
Formula Bar Hidden
Works for me.
Could be done with a few less lines. Private Sub Workbook_Open() Application.DisplayFormulaBar = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayFormulaBar = True End Sub Gord Dibben MS Excel MVP On Thu, 8 Oct 2009 07:18:01 -0700, ub wrote: Hi I have written a VBA code to hide formula bar in the Workbook open event. The code is : If Application.DisplayFormulaBar = True then Application.DisplayFormulaBar = False End if To bring the formula bar back once I exit out of this workbook, I wrote a code in workbook before close event and the code is If Application.DisplayFormulaBar = False then Application.DisplayFormulaBar = True End if I am able to hide the formula bar, but it never brings the formula bar visible for the application. Every time, after using this sheet, I have to manualy add the formula bar. Please advise, how can I correct this problem |
Formula Bar Hidden
Hi Gord
Thanks for the reply. I have a an Exit button on one of the sheets that closes the workbook. I put the code [application.DisplayFormulaBar = True ] in the code of this exit button before the [activeworkbook.save ] and it works now. Thanks to all "Gord Dibben" wrote: Works for me. Could be done with a few less lines. Private Sub Workbook_Open() Application.DisplayFormulaBar = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayFormulaBar = True End Sub Gord Dibben MS Excel MVP On Thu, 8 Oct 2009 07:18:01 -0700, ub wrote: Hi I have written a VBA code to hide formula bar in the Workbook open event. The code is : If Application.DisplayFormulaBar = True then Application.DisplayFormulaBar = False End if To bring the formula bar back once I exit out of this workbook, I wrote a code in workbook before close event and the code is If Application.DisplayFormulaBar = False then Application.DisplayFormulaBar = True End if I am able to hide the formula bar, but it never brings the formula bar visible for the application. Every time, after using this sheet, I have to manualy add the formula bar. Please advise, how can I correct this problem |
All times are GMT +1. The time now is 03:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com