This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using latest version of excel through Office 365. I have recorded macros and now i am not able to run macros at all. I am not even able to see macro code (ALT+F11) that was saved on my modules under my personalworkbook. When I try to record a new macro I get message below. How can I fix this problem?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I can't be sure of what the problem might be. Your previous thoughts on re-installing excel might help.
I have renamed the file but still get syntax error. I get the message regardless of where I am storing the macro (i.e. This Workbook, New Workbook). I am using MS Excel 2016 version and am on Windows 7 Professional SP1.
Only a suggestion but it is possible that personal.xlsb is corrupted. Try re-naming personal.xlsb so that it does not open and then attempt to create a macro.
The only macros that you should create and save in personal.xlsb are those that you want almost every time you open Excel. Macros that are specific to particular workbooks should be in the same workbooks (or in another workbook that opens the specific workbook).
You have not competed the info on the post with your version of Excel and Windows so I can't be specific as to where you will locate personal.xlsb. However, the following site provides some information for various versions.
http://wheatblog.com/2011/08/where-is-the-excel-personal-macro-workbook-located/
The error that I am getting is not in the code of a macro so I have no code to provide. When I hit button to record the macro I get message below. In the VBA editor, I cannot open the modules by double clicking. I am wondering if I just need to reinstall excel.
Without seeing the code that you have then I cannot even guess what the problem might be.
Your comment *"I am not even able to see macro code (ALT+F11) that was saved on my modules under my personal workbook."*If you double click the module name in the Project Explorer (left column of the VBA editor) then you should see your macros. Also clicking the plus signs will expand the tree/s. From your picture, you should be able to open MdMyMacros or Module1 by double clicking. You should also be able to expand MicrosoftExcelObjects and VBAProject (Rentrack Canada .......) unless they are protected and require a password which could apply to MicrosoftExcelObjects.