Solved: How to automate Excel Tools-> Options

[gopi09_m]

Hi,,

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,
Krrishna

[Bob Phillips]

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

[gopi09_m]

thank you.

[Bob Phillips]

Don't forget to mark the thraed as solved using the Thread Tools dropdown.