Sub to lock vbaproject for viewing for all xls in folder using a common password

M

Max

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.
 
M

Max

From the lack of responses, guess there's no way other than to do it
manually, file by file (sigh)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unlock project for viewing within a macro 3
Unable to password-protect "VeryHidden" worksheet 5
Sub to copy n rename book according to list 1
Sub to open n close .xls files in folders 5
Lock VBProject for Viewing using Code 1
Sub to download all linked files in a webpage to folder? 5
Programmatically modifying code using VBE in a protected project 4
Amend sub to read from names in col A 3

Top