Jack, what version of excel are you using? If 2000 or above check tools
macro security and see if it is set to high or very high
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jack Sheet" wrote in message
...
Hi all

After a bit of testing I am satisfied that the macro
Private Sub Workbook_Open()
that resides behind "ThisWorkbook"
is not running at all when the workbook is opened.

Any ideas how I should try to fix this? I tried running Rob Bovey's code
cleaner, and the project compiles ok without any errors.

--
Return email address is not as DEEP as it appears