#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default unlock frozen cells

I opened excell program to add data but it is locked. I can't add nor delete
data. None of the functions work. It opens, but is locked. Help
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 126
Default unlock frozen cells

It might be that you have a 'Freeze Panes' issue.
To unfreeze the windows...
In 2003 -
WINDOWS UNFREEZE PANES
in 2007 +
VIEW WINDOWS UNFREEZE PANES
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Windows 7" wrote:

I opened excell program to add data but it is locked. I can't add nor delete
data. None of the functions work. It opens, but is locked. Help

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default unlock frozen cells

Unprotect the worksheet.

If it has a password, ask the originator for that password.


Gord Dibben MS Excel MVP

On Thu, 29 Apr 2010 10:38:01 -0700, Windows 7 <Windows
wrote:

I opened excell program to add data but it is locked. I can't add nor delete
data. None of the functions work. It opens, but is locked. Help


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
Cursor to upper left of frozen cells (in macro) Mike Excel Worksheet Functions 10 March 6th 09 02:00 AM
Comments addede to cells above frozen panes are not entirely visib Hannes Hallik Excel Discussion (Misc queries) 1 November 29th 07 02:34 PM
Printing Frozen Cells Automatically on every page gin2000 Excel Discussion (Misc queries) 2 July 17th 06 06:14 PM
comments mouseover on frozen cells T-ReXTC Excel Discussion (Misc queries) 1 February 9th 06 10:21 AM
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. Daniel Excel Worksheet Functions 1 June 24th 05 02:59 PM


All times are GMT +1. The time now is 12:43 PM.

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"