Getting this error when trying to execute the following statement in Auto_Open macro:
Application.Calculation = xlCalculationAutomatic We have a group of Excel templates where the Workbook is password protected, as well as some sheets that are protected. We also use .xlam file that contains some macros that are called once the Excel document is opened. Any ideas of setting the Caluclation to Automatic without getting this error message Thanks, Charles -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
