Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jamesbialek
 
Posts: n/a
Default 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
  #2   Report Post  
KenRamoska
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HIDING ROWS IN PROTECTED WORKSHEETS kyoung Excel Discussion (Misc queries) 2 June 9th 05 05:17 AM
How do I unlock specific cells in a spreadsheet that I protected? onemanhattanrebel Excel Discussion (Misc queries) 2 May 8th 05 05:43 PM
How do I unlock a spreadsheet that is password protected? Moke Excel Worksheet Functions 4 April 26th 05 03:27 AM
Protected Worksheets Nikki Patel Excel Worksheet Functions 0 April 22nd 05 08:49 PM
Sorting protected worksheets Drr Excel Discussion (Misc queries) 1 December 3rd 04 08:13 AM


All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"