var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Set Tools>>Options>>General within the Excel VBE by Code
Hi Everybody !
Does anybody know if it is possible to set Tools>>Options>>General within the Excel VBE by Code ? (the equivalent of application.setOptions in Access)
Easy way to check on something like this is to record a macro and go through the steps and options you want to set. Then check the VB Editor to determine how each was obtained.
Recording a Macro doesnt work
thanks for the support, but this doesnt work. The macro recoder wont do it ...
Since I've not done any VB in Access, I'm not sure what application.setOptions does. Looking in the Help files for SetOptions in Access, it appears that some of the items can be done using other menu items in Excel.
What exactly are you trying to do? For instance, if you want to set the page margins, etc.
.PrintTitleRows = ""
.PrintTitleColumns = ""
ActiveSheet.PageSetup.PrintArea = ""
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.5)
.RightMargin = Application.InchesToPoints(0.5)
.TopMargin = Application.InchesToPoints(0.5)
.BottomMargin = Application.InchesToPoints(0.5)
.HeaderMargin = Application.InchesToPoints(0.5)
.FooterMargin = Application.InchesToPoints(0.5)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.PrintQuality = 600
.CenterHorizontally = False
.CenterVertically = False
.Orientation = xlPortrait
.Draft = False
.PaperSize = xlPaperLetter
.FirstPageNumber = xlAutomatic
.Order = xlDownThenOver
.BlackAndWhite = False
.Zoom = 100
.PrintErrors = xlPrintErrorsDisplayed
Last edited by shades; 05-24-04 at