![]() |
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 |
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