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

Ever the pragmatist Simon <vbg

Bob

"Simon Lloyd" wrote in message
...

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

Bob thanks once again for taking the time to reply!

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=266010