Hiding the Row and Column designation bars?

[dimm]

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....

 

[Nick Hodge]

Dimm

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

In the 'This Workbook' module

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[dimm]

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