Is there a way to use VBA to set up a VBA password in another workbook?
 

Hi everyone,

Is there a way to use VBA to set up a VBA password in another workbook?



I know there is way to put VBA module and sub procedure into another
workbook using VBA, but can I password protect them using VBA as well?


AS

Is there a way to use VBA to set up a VBA password in another workbook?
 

Only using sendkeys and that could be unreliable. I have never tried to do
it, but some have previously posted such code in this group. so you could
search groups.google.com archive for this newsgroup.


--
Regards,
Tom Ogilvy


"Excel 009" wrote in message
ups.com...
Hi everyone,

Is there a way to use VBA to set up a VBA password in another workbook?



I know there is way to put VBA module and sub procedure into another
workbook using VBA, but can I password protect them using VBA as well?


AS

Is there a way to use VBA to set up a VBA password in another workbook?
 

Ok. Thanks, Tom.