Microsoft provides programming examples for illustration only, without warranty either
expressed or implied, including, but not limited to, the implied warranties of
merchantability and/or fitness for a particular purpose. This article assumes
that you are familiar with the programming language being demonstrated and the
tools used to create and debug procedures. Microsoft support professionals can
help explain the functionality of a particular procedure, but they will not
modify these examples to provide added functionality or construct procedures to
meet your specific needs.
If you have limited programming experience, you may
want to contact a Microsoft Certified Partner or Microsoft Advisory Services. For more information, visit these Microsoft Web sites:
Microsoft Certified
Partners -
https://partner.microsoft.com/global/30000104Microsoft Advisory Services -
http://support.microsoft.com/gp/advisoryservice
For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
If you want to set the properties of a worksheet to specific values when
you open a workbook, use a Visual Basic for Applications macro to set the
properties when the workbook that contains the worksheet is opened. The
following sample macro demonstrates one way to do this:
' Auto_Open macros run automatically when you open the workbook.
Sub Auto_Open()
With ThisWorkbook.Worksheets("Sheet1")
' Set as many as these properties as you need.
.EnableSelection = xlNoSelection
.EnablePivotTable = True
.EnableOutlining = True
.EnableAutoFilter = True
.DisplayPageBreaks = True
.EnableCalculation = False
End With
End Sub
If you insert this code into a module in the workbook, the macro sets the
properties for worksheet Sheet1 whenever you open the workbook manually.
NOTE: If you use a macro to open the workbook, you must use the
RunAutoMacros method to run the Auto_Open macro.