#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default protected cells

I have a worksheet Ive done and it says that the cells are protected and it's
prompting me for a password. I've never protected it, and its on the computer
that I made the worksheet on.


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default protected cells

I do believe you may have inadvertantly protected and passworded the sheet.

Go to ToolsProtection.

Is "Unprotect Sheet" available?

If so, the sheet is protected.


Gord Dibben MS Excel MVP

On Mon, 19 Feb 2007 15:52:03 -0800, pitstick
wrote:

I have a worksheet Ive done and it says that the cells are protected and it's
prompting me for a password. I've never protected it, and its on the computer
that I made the worksheet on.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default protected cells

Thanks for your help I think your right, yes it's protected so I'm out of
luck, right?

"Gord Dibben" wrote:

I do believe you may have inadvertantly protected and passworded the sheet.

Go to ToolsProtection.

Is "Unprotect Sheet" available?

If so, the sheet is protected.


Gord Dibben MS Excel MVP

On Mon, 19 Feb 2007 15:52:03 -0800, pitstick
wrote:

I have a worksheet Ive done and it says that the cells are protected and it's
prompting me for a password. I've never protected it, and its on the computer
that I made the worksheet on.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default protected cells

Excel's internal security is quite weak and passwords can be broken easily.

See JE McGimpsey's site for info on regaining access to the sheet.

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


Gord

On Mon, 19 Feb 2007 16:19:00 -0800, pitstick
wrote:

Thanks for your help I think your right, yes it's protected so I'm out of
luck, right?

"Gord Dibben" wrote:

I do believe you may have inadvertantly protected and passworded the sheet.

Go to ToolsProtection.

Is "Unprotect Sheet" available?

If so, the sheet is protected.


Gord Dibben MS Excel MVP

On Mon, 19 Feb 2007 15:52:03 -0800, pitstick
wrote:

I have a worksheet Ive done and it says that the cells are protected and it's
prompting me for a password. I've never protected it, and its on the computer
that I made the worksheet on.




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
paste locked cells and unlocked cells in protected sheet Angeline Excel Worksheet Functions 15 November 1st 06 11:51 PM
Protected cells Roy Excel Discussion (Misc queries) 11 August 25th 05 02:33 PM
Tab down instead of right in protected cells Ingibjorg Hinriksdottir Excel Discussion (Misc queries) 3 August 5th 05 02:11 PM
Seeing Protected Cells Dave Excel Discussion (Misc queries) 1 June 16th 05 11:19 PM
cells not protected Tedr Excel Discussion (Misc queries) 1 December 1st 04 11:36 PM


All times are GMT +1. The time now is 04:05 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"