I tried your solution...but for the life of me couldnt find the macr
security setting on this pc.....i have been all through excel on her
and even looked at the unopened properties, still no joy. So i hav
just travelled over to another building where i created the workboo
(the workbook is on a network) on a particular pc opened the program n
problems and accessed the VBA project by entering my password, i the
removed the password and unchecked the Lock check box, have come al
the way back here and it works fine....very strainge!!!!, i can eve
lock and unlock the project here now!

Bob thanks once again for taking the time to reply!

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=26601