ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sub to lock vbaproject for viewing for all xls in folder using a common password (https://www.excelbanter.com/excel-programming/404226-sub-lock-vbaproject-viewing-all-xls-folder-using-common-password.html)

Max

Sub to lock vbaproject for viewing for all xls in folder using a common password
 
I've got 30+ .xls files in a folder (eg: E:\Max\Excel) that I would like to
protect, ie Lock vbaproject for viewing using a common password, eg:
vbapaswrd. Is there a sub which can do this? Thanks.



Max

Sub to lock vbaproject for viewing for all xls in folder using a common password
 
From the lack of responses, guess there's no way other than to do it
manually, file by file (sigh)




All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com