View Full Version : Solved: How to automate Excel Tools-> Options

05-03-2008, 11:03 PM

How do i set the "tools-> options -> view tab-> under windows options -> Row and column headers" programmatically when i open the excel file contain the code for this.
My requirement is to hide the Row and column headers when i open the excel file containing this macro.

Thanks and REgards,

Bob Phillips
05-04-2008, 01:07 AM
Private Sub Workbook_Open()
ActiveWindow.DisplayHeadings = False
End Sub

This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code

05-04-2008, 09:36 PM
thank you.

Bob Phillips
05-05-2008, 01:57 AM
Don't forget to mark the thraed as solved using the Thread Tools dropdown.