"Can't save file because it's read-only" problem

[losamfr17]

Hi,

I want to delete a previously recorded macro. When i open the macro pop up menu from the ribbon to select and delete the macro, I get an error message saying "Can't save 'Personal2.xlsb' because the file is read-only.
I don't want to save it under a new name, i want to reduce the list of macros. Any thoughts please?

Thank you!

 

[Logit]

I don't see anything in your code that would cause those other workbooks to be activated. Perhaps when you deleted the other macros, that did the trick ?
I've had Excel do the same thing to me occasionally, without explanation, here.

Hopefully it's just a temporary glitch ?

 

[losamfr17]

Or maybe it's because I had clicked "Unhide" the view the workbook.

 

[losamfr17]

Thank you so much for your time.