I don`t have a remove option for my modules

[PLAYBOY]

How can I remove a module while I don`t have the remove option when I right-click?

I`ve read and followed the instructions on how to remove a module on few sources but I`ve never removed a module before so maybe that information has been outdated now and I need to do something else than just right click on it now. I couldn`t figure out how to remove a module as I don`t have the option to when I right-click as you can see in the screenshot

PS: It`s not a locked document. I made the worksheet and own all the right

Screenshot 2018-10-19 00.11.38.png

[Glenn Kennedy]

I'm using Excel 2016 and when I go to the VBA editor (ALT-F11) and right click on any module... I get the remove module. Is there any save protection on the sheet?

[pjwhitfield]

Does this happen for other workbooks or just this one?

[PLAYBOY]

I'm using Excel 2016 and when I go to the VBA editor (ALT-F11) and right click on any module... I get the remove module. Is there any save protection on the sheet?

No. Never had any issues. As explained above, I created this workbook and I own all the rights. Never put any restrictions on it at all

Does this happen for other workbooks or just this one?

No. Weird

[AliGW]

Is this particular file saved on OneDrive, by any chance? If so, what happens if you save it to a non-OneDrive folder?

[PLAYBOY]

It`s not. It`s in Google Drive and also in my Hard Disk

[AliGW]

And it fails to work when opened from either location?

[PLAYBOY]

Yeah




Had to fill the message with at least 10 characters...

[alansidman]

If you highlight the module and click on File, do you then have the opportunity to remove the module?

[Kyle123]

You're in break mode. Press stop on the tool bar at the top. You'll then get the regular options