ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protecting Multiple Workbooks? (https://www.excelbanter.com/excel-programming/329383-protecting-multiple-workbooks.html)

Bosco

Protecting Multiple Workbooks?
 
Is there a way to password protect mutiple Excel workbooks at the same
time without using an external utlity? To my knowledge, only one Excel
workbook can be saved and given a password at a time, but protecting
several at a time would be a real time saver.

Bosco


Dave Peterson[_5_]

Protecting Multiple Workbooks?
 
You could have a macro that opens the workbook and saves it with a password
(then closes it).

Or is that an external utility?

Bosco wrote:

Is there a way to password protect mutiple Excel workbooks at the same
time without using an external utlity? To my knowledge, only one Excel
workbook can be saved and given a password at a time, but protecting
several at a time would be a real time saver.

Bosco


--

Dave Peterson


All times are GMT +1. The time now is 10:00 AM.

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