VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Word to Excel: Export comments with text and line number 0
Summing totals on separate worksheet based on 2 criteria 4
Excel Macro to un-mute Audio/speakers. 15
VISIO from Excel VBA 0
2003 file with VBA to 2007 1
How do I copy some cells(including formatting) and save as image fileusing VBA? 1

Back
Top