Running Macro on all the spreadsheets in a workbook

[Guest]

Question:
I have created macro for searching, and the macro can only search one spread at a time. So, I am wondering is it possible to make the macro search all the spreadsheets in a workbook at the same time?
Please Help me
Thank you in advance

 

[Guest]

Hello,

I beleive it is quite easy, I will call your macro that searches the worksheet as MySearchMacroName.
Just create a new macro as follows:


Sub SearchAllSheets()
For Each Worksheet In Worksheets
Sheets(Worksheet.Name).Select
Call MysearchMacroName
Next Worksheet
End Sub

Pierre

 

[Guest]

Hello
I copy the code and paste it in ThisWorkBook and change the name of the macro. However it doesn't work
Did i do something wrong?
Thanks