Personal macro workbook un-editable macro's but normal workbook is fine

[crowso]

I'm trying to help someone who's run into a problem and to be honest it's baffled me! I've tried looking around for an answer but I haven't come across anything like this.

So when they go into their macro list (see attached image) for any macros stored in their personal workbook they can't edit them, the only options available are "Run" and "Step Into", but if they select a macro in any other workbook then they can select edit. However if they go into VBA they can go into the macro that way, create modules and edit macros. Does anyone know why the first route isn't working

 

[6StringJazzer]

I have never seen this. My first thought would be that somehow PERSONAL.xlsb has been opened as Read-Only. If they go into the VBA editor and make changes as you describe, are they able to actually save those changes?

 

[crowso]

I have never seen this. My first thought would be that somehow PERSONAL.xlsb has been opened as Read-Only. If they go into the VBA editor and make changes as you describe, are they able to actually save those changes?

That was my first thought, but they're able to make changes and save but only if they go through VBA editor