VBA
 

I am trying to set the default sheet direction for excel in excel 2007. I
was advised to use VBA and use this code line: Application.DefaultSheet
Direction=xlLTR.

At the risk of showing total ignorance, where do I do this? In other words,
can someone give me kind of a step by step....go to, click on, set, etc. etc.
I found a VBA certificate, but I don't find any areas where I can use it.

Thanks,
--
Jim

VBA
 

macros are great but only if enabled on your pc, for a non macro option which
is probably the advice you were looking for


go into options, then select the edit tab, their is a move selection AFTER
ENTER OPTION, select right from the drop down menu





"Jim Crawford" wrote:

I am trying to set the default sheet direction for excel in excel 2007. I
was advised to use VBA and use this code line: Application.DefaultSheet
Direction=xlLTR.

At the risk of showing total ignorance, where do I do this? In other words,
can someone give me kind of a step by step....go to, click on, set, etc. etc.
I found a VBA certificate, but I don't find any areas where I can use it.

Thanks,
--
Jim