How do i unlock protected worksheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Unlock Workbook 1
How do I automaticly carry a month end total over 1
Lock Unlock Cell Protection 2
How do I put a formula into an unlocked cell on protected workshee 1
How is everyone doing? 23
I have a column of 50 names 2
protecting worksheets 1
How to enable the Unprotected Worksheet menu 2

Back
Top