View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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