Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

some macros not working in excel 2016

0

Hi,

First of all thank you for the weekly updates, its really very helpful.

I have many macros that were written in excel 2016.

Now we have upgraded our MS office to MS 365 ( excel 2016). Now, some macros work fine and in some does not.

Can anybody tell me what needs to be done ( may be reference files needs to be added) ?

Answer
Discuss

Answers

0
Selected Answer

There shouldnt be a compatibility issue; however, many things could go wrong.

  • Check security settings to make sure the macros are allowed to run.
  • Make sure sheets that don't exist are not referenced.
  • Make sure you are trying to run them on a local install of Excel.

If that doesnt work, post some code and tell us exactly which part is failing. You havent given enough information to properly troubleshoot the issue but maybe the above suggestuons can help.

Discuss

Discussion

Thanks Don, I will follow your instruction what you said and if need be I will get back with better inputs.. Thanks again.
Deva (rep: 4) May 22, '17 at 1:22 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login