Hiding the Headings, Gridlines & Formula bar

**SURESH G** · 03-07-2012, 01:39 AM

Dear All,

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

**Paul** · 03-07-2012, 01:57 AM

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.

Please Login or Register  to view this content.

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** · 03-07-2012, 02:31 AM

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.

**royUK** · 03-07-2012, 03:16 AM

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** · 03-07-2012, 03:21 AM

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

**TAMILARASAN** · 03-07-2012, 03:26 AM

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.