Macros Excel 2013 "unable to record"

I wish to start a macro in excel 2013.  Ok, first open blank excel page. Then click on View. Next click on Macro , Click on the drop down arrow. So far good. click on Record Macro. Then  dialogue box opens up.  Set up Macro Name, then add description. Click on "ok' then i get this message. When I go to status bar at bottom, no icon for recording.  What to do next???

    Small Microsoft Office Widow pops up

inside Window    "Unable to record"

Check the Macro Security settings:-

https://support.office.com/en-us/article/Create-or-delete-a-macro-f3eb0fa3-4c18-498a-9235-c66ba8e78149?ui=en-US&rs=en-US&ad=US

In the above hyperlink towards the top at point number 2 it states:-

You may first need to set the security level to enable all macros. To do this:

Note what the above line says:-

may

Does that help?

Hi May,

     I did try this earlier and again just now. The results are the same. I did change the security level.

Thanks,

Bob

Hi,

take a look here, maybe could help

https://www.youtube.com/watch?v=vtTa8y6i_rM

Hello,

   Thank you for your reply. I gave it a try. Unfortunately it did not work. This excel program is from

Office 365.  The excel macro does not work on my desktop, however the same key code was used on the laptop and it works well there. 

Hi,

try and here..

https://www.youtube.com/watch?v=2Oq27zdbNJs

https://www.ablebits.com/office-addins-blog/2014/07/22/enable-macros-excel/

It is possible that your file got corrupted. If you have a previous version, then try to open that version and record a macro there. If it works, then you know that the other file is indeed corrupted.

You can recovery a previous version, by going into a backup folder. Try this:

Select the folder where the file is save

Right click

Select "Properties"

Select "Previous Version"

Select a date when you know the file worked just fine

Open the excel version

Try to record there, if works, save that version and then try to copy any data from the old version, but don't copy the tabs or macros. 

Good luck and happy macronize