PDA

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



gopi09_m
05-03-2008, 11:03 PM
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

xld
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

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

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