ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i unlock protected worksheets? (https://www.excelbanter.com/excel-worksheet-functions/31861-how-do-i-unlock-protected-worksheets.html)

jamesbialek

How do i unlock protected worksheets?
 
I have an Excel document that I have used in my old workplace to track Petty
Cash.
I am now using it within my new work environment, and want to change the
house name, dates, etc.. so they are on all sheets.

For some reason on the tabs, not all options are able to access (they are
grey, instead of black). I also want to bold the name of the house, but the
bold, underline and italicize options aren't able to be pushed..

Why and any quick ways to get around that?

It is asking me for a password when I look to unprotect the sheet, but I
have no idea of it, can i get around that?

james

KenRamoska

Hi James,
I think you will have to copy / paste all of this into a new sheet.
I don't know of a way to get around a password. If we did then protection
would be a useless feature I guess.
Ken

"jamesbialek" wrote:

I have an Excel document that I have used in my old workplace to track Petty
Cash.
I am now using it within my new work environment, and want to change the
house name, dates, etc.. so they are on all sheets.

For some reason on the tabs, not all options are able to access (they are
grey, instead of black). I also want to bold the name of the house, but the
bold, underline and italicize options aren't able to be pushed..

Why and any quick ways to get around that?

It is asking me for a password when I look to unprotect the sheet, but I
have no idea of it, can i get around that?

james



All times are GMT +1. The time now is 05:37 PM.

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