ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unprotecting a Protect Worksheet (https://www.excelbanter.com/excel-worksheet-functions/125559-re-unprotecting-protect-worksheet.html)

Ang

Unprotecting a Protect Worksheet
 
This is great - thx for sharing! We all get those awfully formatted
spreadsheets....and I double-spit promise and pinky swear that I will never
use this for anything sinister....
-Ang

"Gord Dibben" wrote:

See JE McGimpsey's site.

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

But you must double-spit promise that nothing sinister is intendedg


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 13:26:01 -0800, JDC wrote:

Is there a way to unprotect a worksheet received from a third party that is
locked? This is nothing sinister, I am just trying to reformat a worksheet
that was protected by someone who did not do a good job in setting up the row
and column heights.

Thanks in advance.




Gord Dibben

Unprotecting a Protect Worksheet
 
I feel better already<g


Gord

On Wed, 10 Jan 2007 08:25:01 -0800, Ang wrote:

This is great - thx for sharing! We all get those awfully formatted
spreadsheets....and I double-spit promise and pinky swear that I will never
use this for anything sinister....
-Ang

"Gord Dibben" wrote:

See JE McGimpsey's site.

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

But you must double-spit promise that nothing sinister is intendedg


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 13:26:01 -0800, JDC wrote:

Is there a way to unprotect a worksheet received from a third party that is
locked? This is nothing sinister, I am just trying to reformat a worksheet
that was protected by someone who did not do a good job in setting up the row
and column heights.

Thanks in advance.






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

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