No, it is fine in Thisworkbook, but the workbook procedures must be in
ThisWorkbook as shown, but it would help if I hadn't included a space in the
open procedure


Private Sub Workbook_Open()
ListSheets
End Sub


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"davesexcel" wrote
in message ...

Hi Bob

I get a sub not defined at this point, when I open the workbook, should
the list sheets macro be in a regular module?
nope just tried it, still says undefined sub or function


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517213