troubleshooting Question

VBA - Disable Excel 2010 Compatibility Checker

Avatar of ocaccy
ocaccyFlag for Japan asked on
Microsoft ExcelVisual Basic.NETVisual Basic Classic
2 Comments1 Solution2614 ViewsLast Modified:
Hi everyone.

I put these instructions in the VBA script, but the window keeps popping compatibility checker.
How should the correct syntax to save and not ask for confirmation of compatibility?

Sub savePlan()
    Call AjusteDeLayout_1
    
    Application.EnableEvents = False
    ActiveWorkbook.Save
    Application.EnableEvents = True
    Range("A2").Select
End Sub
compatibility-checker.PNG
ASKER CERTIFIED SOLUTION
Randy Downs
OWNER

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros