There's GOT to be something else going on.
I created a new file with.xlam extension.
Protected the Sheet and Workbook
Created a sub called Init with only the line:
Application.Calculation = xlCalculationAutomatic
Created a Workbook_Open sub
calling Init.
It worked just fine.
I also tried it with an Auto_Open sub, it worked also.
So, there must be something else going on.
Do you know if it is user-specific or workstation specific?
(test it on another PC, and with another user)
Can you send me some sample files to test?
Paul
On Jan 4, 12:42 pm, crconti <charlesrcon...@hotmail.com> wrote:
> 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
