Hey Udin,
try this code
Sub HideHeadings()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
ActiveWindow.DisplayHeadings = False
Next ws
End Sub
On Fri, Aug 26, 2011 at 2:04 AM, Udin Haeruddin wrote:
> how about hiding row and column heading for all sheet using
Go To View and Uncheck the Heading CheckBox.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAJID MEMON
Sent: Thursday, August 25, 2011 5:59 PM
To: Excel Group
Subject: $$Excel-Macros$$ BarHide
Dear Experts,
Plz give attachment requirement code
how about hiding row and column heading for all sheet using VBA? Why the
code below doesn't work?
*Sub HideRowColEntireWorkbook()*
> Dim sh As Worksheet
> For each sh in ThisWorkbook.Worksheets
> sh.DisplayHeadings=False
> Next sh
> *End Sub*
>
2011/8/25 NOORAIN ANSARI
> Dear Sajid,
>
> Pls try
Dear Sajid,
Pls try
To Hide Row/Column Heading..
*Sub Hide_Rowcolumn_Heading()
ActiveWindow.DisplayHeadings = False
End Sub
*
To Unhide Row/Column Heading..
*Sub Hide_Rowcolumn_Heading()
ActiveWindow.DisplayHeadings = True
End Sub
*
On Thu, Aug 25, 2011 at 5:58 PM, SAJID MEMON wrote:
> Dear E
goto excel option and click on advanced then un check
show row and column headers
On Thu, Aug 25, 2011 at 5:58 PM, SAJID MEMON wrote:
> Dear Experts,
>
> Plz give attachment requirement code.
>
> Regards
>
> Sajid memon
>
> --
>
>
Dear Experts,
Plz give attachment requirement code.
Regards
Sajid memon
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
ht
