![]() |
Locked VBAproject due to macro fault????
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 |
Locked VBAproject due to macro fault????
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 |
All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com