How can i hide row & column headers in excel whether through VBA or any other
method...

Tools, Options, View Tab - near bottom uncheck Row & column headers

"Irfan Khan" wrote:

> How can i hide row & column headers in excel whether through VBA or any other
> method...

In XL 97 to 2003: Tools | Options ->open View tab; in lower third "Windows
Options" group uncheck Row and Column Headers.

In XL 2007: Office button (colourful circle at top left); Excel Options
(bottom of dialog); open Advanced group; locate Display Option for This
Worksheet; uncheck Show Row and Column Heading

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Irfan Khan" <(E-Mail Removed)> wrote in message
news:41E10EDA-3BDA-4DCF-AE0F-(E-Mail Removed)...
> How can i hide row & column headers in excel whether through VBA or any
> other
> method...

On Nov 2, 8:35 am, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:
> In XL 97 to 2003: Tools | Options ->open View tab; in lower third "Windows
> Options" group uncheck Row and Column Headers.
>
> In XL 2007: Office button (colourful circle at top left); Excel Options
> (bottom of dialog); open Advanced group; locate Display Option for This
> Worksheet; uncheck Show Row and Column Heading
>
> best wishes
>
> --
> Bernard V Liengme
> Microsoft Excel MVPwww.stfx.ca/people/bliengme
> remove caps from email
>
> "Irfan Khan" <IrfanK...@discussions.microsoft.com> wrote in message
>
> news:41E10EDA-3BDA-4DCF-AE0F-(E-Mail Removed)...
>
> > How can i hide row & column headers in excel whether through VBA or any
> > other
> > method...

ActiveWindow.DisplayHeadings = false