Useful Application Objects
***Use Screen Updating
Application.ScreenUpdating = False to deactivate
Application.ScreenUpdating = True to activate
**Turn Off automatic calculations
Application.Calculation = xlCalculationManual 'To turn
off the automatic calculation
Application.Calculation = xlCalculationAutomatic 'To
turn On the automatic calculation
***use this code for calculations
whenever you want
ActiveSheet.Calculate ' To calculate the formulas of
Active Worksheet
Application.Calculate ' To calculate the formulas of
Active workbook or all workbooks in current
***To
turn off on cut copy mode
Application.cutcopymode=False or true
Application.Displayhorizontalbar=True or
false?Application.Version
***To
Turn on/off alerts
Application.displayalerts=true or false
Application.displaycommentindicator
Application.dataentrymode=false or
trueApplication.displayformulabar=true or false
Application.displayfullscreen=true or false
No comments:
Post a Comment