Hiding the Row and Column designation bars?
 

Hi again everyone, :-)

Is there a command I can put into my Auto-Open macro to ensure that the Row
and Column designation bars (A,B,C,D,E.... & 1,2,3,4,5,6,7....etc) are hidden?

Thanks for any ideas....

Hiding the Row and Column designation bars?
 

Dimm

Private Sub Workbook_Open()
ActiveWindow.DisplayHeadings = False
End Sub

In the 'This Workbook' module

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"dimm" wrote in message
...
Hi again everyone, :-)

Is there a command I can put into my Auto-Open macro to ensure that the
Row
and Column designation bars (A,B,C,D,E.... & 1,2,3,4,5,6,7....etc) are
hidden?

Thanks for any ideas....

Hiding the Row and Column designation bars?
 

Thanks Nick....again! ^^ .... I'll try that first thing tomorrow aswell. :-)

"Nick Hodge" wrote:

Dimm

Private Sub Workbook_Open()
ActiveWindow.DisplayHeadings = False
End Sub

In the 'This Workbook' module

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"dimm" wrote in message
...
Hi again everyone, :-)

Is there a command I can put into my Auto-Open macro to ensure that the
Row
and Column designation bars (A,B,C,D,E.... & 1,2,3,4,5,6,7....etc) are
hidden?

Thanks for any ideas....