View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick Hodge[_2_] Nick Hodge[_2_] is offline
external usenet poster
 
Posts: 185
Default 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....