Macros to set options on every sheet

Posted by Jonathan on October 03, 2001 1:41 PM

Is there a way to set an option every time you go to any sheet in any workbook in Excel 97?

I want to set the transition formula entry on (Tools-Options-Transition-transition formula entry) I guess you would put this in the personal.xls. This option needs to be set everytime you you go to a new sheet. How do you do this? Here is what I have so far to set the option for one sheet.

Sub transition()
'

'
With application
.TransitionMenuKey = "/"
.DefaultSaveFormat = xlNormal
End With
ActiveSheet.TransitionFormEntry = True
End Sub

How do I make it so it runs everytime I go to a new sheet in any workbook?

Thanks,
Jonathan

Posted by Ted on October 03, 2001 3:25 PM

Just change the setting in Book.xlt to what you want (then you don't need your macro).

Posted by Jonathan on October 04, 2001 3:55 AM

I searched my hard drive- I don't have a book.xlt.

Posted by Ted on October 04, 2001 5:01 AM

Sorry, was using the default name I previously created.
To see how to do, have a look at "Create a sheet template for new worksheets" in the Help file.

Posted by jonathan on October 04, 2001 6:14 AM

Worked great- thanks