Some of my spreadsheets are getting corrupted, however this corruption seems
to consist of a certain character always being replaced with another, so I
know how to fix this: all I need to do is perform a global search and replace
within the code.

I know that accessing the code in the project to add/remove procedures and
so forth is possible, but is there a way of doing this too?