Hiding the Headings, Gridlines & Formula bar

[SURESH G]

Dear All,

Please suggest me marco code for Hiding the the Headings, Gridlines & Formula bar.

[Paul]

Hi Suresh,

Did you try recording a macro of you performing those steps? It provides the code you'll need to add to a macro.

Sub Macro1()
    Application.DisplayFormulaBar = False
    ActiveWindow.DisplayGridlines = False
    ActiveWindow.DisplayHeadings = False
End Sub

Note: If other users are going to be accessing this workbook, you'll want to add code to set them back to True whenever they deactivate the workbook that includes the code - otherwise they'll open other workbooks and these objects will be hidden there, too.

[SURESH G]

Dear Paul,

Basically i don't know how to record the marco. I copied the code which you provided and opened the new excel workwook and hitted Alt+F11 and pasted there. It is not working. can you provide me any link to learn Marco from basic.

[TAMILARASAN]

You can easily record Macro Using Developer -> Record new Macro -> Just click Ok & continue with Your work. It will create the macro coding what you had worked out. Thn you can run the macro when ever you required.
Note: Pls check that you have enabled your macro settings.

[royUK]

I really don't think that you should be messing around with user settings like this. You need to be able to restore all setting.

[Paul]

Did you run the macro after pasting it into the VB Editor?

[royUK]

You really don't need VBA to do this, just edit the worksheets manually to hide Gridlines, etc.

I wouldn't recommend hiding the Formula Bar