DUHHH why didn't I think of this. Found out after posting the question.
Thanks for the reply
Curt

"Norman Jones" wrote:

Hi Curt,

close and re-open Excel.

Should have read:

close and re-open the workbook.


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Curt,

After protecting the project, to activate the protection, save the
workbook, close and re-open Excel.


---
Regards,
Norman


"Curt" wrote in message
...
I went into vba propertiers and password protected. Still after f8 puts
you
right back into the vba code. No request for password. Is ther something
I am
missing?
Thanks

"Leith Ross" wrote:


Hello Matt,

Not to my knowledge. Opening the file is what places it into Excel's
Workbook Collection. Until it is in the collection, VBA can't access
the object's properties. Add to that password protection is an internal
routine that isn't exposed outside of the Workbook. Maybe there is a way
using some other language or method, but with VBA the answer is no.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=480862