See Chip Pearson's page on working in with code in the VBE:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

Chris Gorham wrote in message
...
Hi,

I'm designing a tool to cycle through the sheets in a
workbook to detect if there is any code behind them. In
workbooks with a large number of sheets this can be quite
tricky to detect using the VBA editor.
Does anybody know how to do this...??

Rgds

Chris