search project

[methody]

Hello there
I have large and fairly complicated workbook with many worksheets, modules, macros, and userforms.
Previoulsy I have gone to great lengths to protect the workbook by using protect and unprotect commands at various places. Now I need to remove all these commands which are found thoroughout the project.
I have done it as thoroughly as possible manually but I know there are still some there. Is there any way of searching for these commands within the project or code that would fine them.
thanks

 

[VoG]

Try Searching for Text in a Module http://www.cpearson.com/excel/VBE.aspx

 

[methody]

thanks for that.
In principle that would be helpful. I have tried to follow the instructions including the bit at the top but I can't get it to work. eg where do I put the searchmodule code

 

[VoG]

The code goes into a regular module. You would need to change the parts in red

        Set VBProj = ActiveWorkbook.VBProject
        Set VBComp = VBProj.VBComponents("Module1")
        Set CodeMod = VBComp.CodeModule
        
        FindWhat = "findthis"

and you might want to change

Debug.Print "Found at: Line: " & CStr(SL) & " Column: " & CStr(SC)

to write to a sheet.