1

I wanted to make a Macro in Excel 2016 (under Win 10). I chose the "Record Macro" button. After opening the floating window and making a name for the macro, I click on the "OK" button. After that, the Excel goes to hang mode for two, three seconds and then the Excel restart itself. On the other hand, the button "Use Relative Reference" in Developer menu does not work and it's highlight always.

Shortly, I can not make a Macro in Excel 2016 under Win 10, any advice is appreciated. Thanks Guys ...

  • Try Disabling Hardware Acceleration in Advanced Options. File-->Options-->Advanced-->Display and Check Disable hardware graphics acceleration. – patkim Jul 13 '18 at 19:22
  • @pat2015 Thank you for your advise I done but the problem is still there. – Kasra Jul 13 '18 at 19:39
  • Try to Repair Office installation and see if it fixes anything. – patkim Jul 13 '18 at 20:13
  • @pat2015 ... thank you my friend, I did it (repairing the office) but the issue is still yet. – Kasra Jul 14 '18 at 9:31
  • Might not be so relevant but just also try completely disabling any third party antivirus software if installed including its service in control panel. Are you recording a macro on a blank worksheet or on a sheet that's already saved as .xlsm? – patkim Jul 14 '18 at 12:07
1

I found the solution to this issue! ... I did a click on the "Reference ..." in VBA Developer in Excel and I get this message: Unrecognised Project Language then I went to the Regional Setting and I cleaned up (uncheck) the Beta: Use Unicode UTF-8 ... Now the VBA work correctly.

0

In my case if I entered record macro or even the macro area the excel file restarted every time without accessing the macro areas. I found the following worked for me. Went to xlstart folder and deleted the personal.xlsb file Opened a new file and saved as Personal.xlsb. Everything worked again but of course i lost all the existing macros that were in the original file. Thankfully I had copy pasted these to a word file. Mike

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.