Macro won't save in Excel 2013

[Celtic1984]

Can anyone help me? I've attempted several times without success to save a macro, once I've finished the recording. I did save the files as 'xlsm' or as a macro-enabled worksheet. I am using a new computer, windows 10. Not sure if that is a factor. I do know that when I saved the macro, I did not see "personal workbook' as an option. In the past, I've seen a workbook that opens in the background while I'm running a macro. Do I need to make a setting adjustment in Excel? And finally, I've read on older threads of saving the file as 'PERSONAL.XSLB' Binary Workbook. Not sure if this pertains to me. Appreciate the help, in advance. Mike

 

[Joe4]

Welcome to the Board!

Macros can be saved to the Personal Macro Workbook, but do not have to be. They can be saved it any Excel workbook. It sounds like you have saved them to the actual workbook.
If you want to create a Personal Macro Workbook, the easiest way is to record a new Macro, and select the "Personal Macro Workbook" as the location that you want to save it to. This will create that Personal Macro Workbook for you.

If you have not already done that on a new computer, you probably do not have a Personal Macro Workbook yet.

 

[Celtic1984]

I attempted to save as a 'Personal Macro Workbook' and it did not save. That is, the next time I attempt to run the macro, I cannot see the personal macro workbook as an option to save. I'm using MS 2013 version. I'm saving the raw data file as 'xlsm' macro-enabled worksheet. Is that the correct path? Not sure what I'm doing wrong. Or do you think I need to save as a Binary Workbook?

 

[Joe4]

Try this:

1. Record a new macro
2. Elect it to save to your Personal Macro Workbook
3. Stop recording the macro
4. Go to View Macros, select the one you just saved, and choose the Edit Button
5. Add a simple new macro in there like this:

Sub Test()
    MsgBox "Good morning!"
End Sub

6. Close down Excel - it should ask you if you want to save changes to your Personal Macro Workbook - BE SURE TO SAY YES!
7. Re-open Excel
8. Go to View Macros
9. Change the Macros In option to the PERSONAL option

Do you see the Test macro listed there?

 

[Celtic1984]

Just attempted to follow your instructions. Was moving along fine until an error stated "cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command". How do I 'unhide' the workbook?

 

[Joe4]

Sounds like it may be disabled.
See her for instructions on enabling it: https://answers.microsoft.com/en-us...o-that-i/32c960ab-724a-474e-8eec-c1356eeb5971

 

[Celtic1984]

I performed that check. This file was not 'disabled'. I'm at a loss and don't quite understand what the issue is. Any additional suggestions? Really appreciate it.

 

[Joe4]

Only other suggestion I have is to try removing/deleting all Personal Workbooks you currently have out there, and try starting again.

 

[Celtic1984]

Will do. Thanks.

 

[Celtic1984]

So removing the workbook and starting over did not solve my issue. Would you like me to attach a workbook, to view personally?