use macro to find and replace specific code in vba

i am wondering if it is possible to have a macro that opens the vbe for the active worksheet, finds the code line

Please Login or Register  to view this content.

and replaces it with

Please Login or Register  to view this content.

or something similar.

what i am trying to accomplish is have a macro permanently change the position and height of the active worksheet. when i run the macro it should go into the "This Workbook" excel object module for the active workbook, find the specific line of code (no matter its location in the code), and subtract "9" from its current value

thanks

Hi Hopeful,

Try the attached file (tested using Excel 2003), with full code following. It is MANDATORY that the PREREQUISITES exist, or the code will not compile and/or you will get runtime errors. I want to thank all those who provided the referenced links. Without those links, I wouldn't have known where to start.

Lewis

In an ordinary code module:

Please Login or Register  to view this content.