ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Removing protection from excel worksheets (https://www.excelbanter.com/excel-worksheet-functions/79461-removing-protection-excel-worksheets.html)

Rick Wilson

Removing protection from excel worksheets
 
I want to remove protection from a number(about 200) of similar worksheets in
a workbook simultaineoulsy. They all have the same password.

EdMac

Removing protection from excel worksheets
 

Suggest you download ASAP utilities (ASAP-utilities.com) - it has this
as a standard feature and its free. It has a lot of other useful
utilities as well!

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=526080


JMB

Removing protection from excel worksheets
 
Here's another one I've found useful.

http://www.mcgimpsey.com/excel/removepwords.html

"Rick Wilson" wrote:

I want to remove protection from a number(about 200) of similar worksheets in
a workbook simultaineoulsy. They all have the same password.


Rick Wilson

Removing protection from excel worksheets
 
Thanks Ed that worked at treat, yes I agree very useful utilities

"EdMac" wrote:


Suggest you download ASAP utilities (ASAP-utilities.com) - it has this
as a standard feature and its free. It has a lot of other useful
utilities as well!

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=526080




All times are GMT +1. The time now is 04:15 PM.

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