Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|