Broro183, I have found out what Option Explicit means and have put this
to the top of my "ThisWorkbook" page - I had it half way down. Did the
file keep looping when you tried your VBA, if I run Materials Manager
and save then fine - the file saves - if I press save as, then your vba
runs and a new file is saved - if I click close, then I am asked to save
so I do - then the page wont close - it keeps saying "Do you want to
save changes you made to Materials Manager.xls?" when I have not made
any changes - any thoughts?


--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=537559