Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phil-in-SF
 
Posts: n/a
Default Help! Still looking for answr: editing unlocked cells in prtctd wr

I'm using Excel 2003, and I can't seem to edit the contents of an unlocked
cell when I protect the worksheet. Hitting F2 in these cells deletes the
content of the cells. I am allowed to enter in new data, but I would prefer
that F2 would work as it does with unprotected worksheets (i.e., and allow me
to modify the cell's existing information). I've done a lot of testing on
this, including on other machines, even other versions (2000 and 2002). Is
this really an "undocumented feature" or am I losing my mind?


  #2   Report Post  
Posted to microsoft.public.excel.misc
Dominic
 
Posts: n/a
Default Help! Still looking for answr: editing unlocked cells in prtctd wr

Phil,

I am using Excel2000 on Win2000 and when I press F2 in an unlocked cell in a
protected worksheet, F2 functions as expected. That is, it lets me edit (add
to) the existing entry.

HTH

"Phil-in-SF" wrote:

I'm using Excel 2003, and I can't seem to edit the contents of an unlocked
cell when I protect the worksheet. Hitting F2 in these cells deletes the
content of the cells. I am allowed to enter in new data, but I would prefer
that F2 would work as it does with unprotected worksheets (i.e., and allow me
to modify the cell's existing information). I've done a lot of testing on
this, including on other machines, even other versions (2000 and 2002). Is
this really an "undocumented feature" or am I losing my mind?


  #3   Report Post  
Posted to microsoft.public.excel.misc
Phil-in-SF
 
Posts: n/a
Default Help! Still looking for answr: editing unlocked cells in prtct

Dominic - Thanks for the response. I was mistaken - I only tested on Excel
2002 and 2003, not Excel 2000, and both on Win2000. So not sure what to do
next, as it is not working....

"Dominic" wrote:

Phil,

I am using Excel2000 on Win2000 and when I press F2 in an unlocked cell in a
protected worksheet, F2 functions as expected. That is, it lets me edit (add
to) the existing entry.

HTH

"Phil-in-SF" wrote:

I'm using Excel 2003, and I can't seem to edit the contents of an unlocked
cell when I protect the worksheet. Hitting F2 in these cells deletes the
content of the cells. I am allowed to enter in new data, but I would prefer
that F2 would work as it does with unprotected worksheets (i.e., and allow me
to modify the cell's existing information). I've done a lot of testing on
this, including on other machines, even other versions (2000 and 2002). Is
this really an "undocumented feature" or am I losing my mind?


  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Help! Still looking for answr: editing unlocked cells in prtctd wr

You have other responses at your other thread.

Phil-in-SF wrote:

I'm using Excel 2003, and I can't seem to edit the contents of an unlocked
cell when I protect the worksheet. Hitting F2 in these cells deletes the
content of the cells. I am allowed to enter in new data, but I would prefer
that F2 would work as it does with unprotected worksheets (i.e., and allow me
to modify the cell's existing information). I've done a lot of testing on
this, including on other machines, even other versions (2000 and 2002). Is
this really an "undocumented feature" or am I losing my mind?


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
Phil-in-SF
 
Posts: n/a
Default Help! Still looking for answr: editing unlocked cells in prtct

Hi Dave - Yes, thank you. In hindsight, I probably should have posted only
once. First time rookie mistake....

"Dave Peterson" wrote:

You have other responses at your other thread.

Phil-in-SF wrote:

I'm using Excel 2003, and I can't seem to edit the contents of an unlocked
cell when I protect the worksheet. Hitting F2 in these cells deletes the
content of the cells. I am allowed to enter in new data, but I would prefer
that F2 would work as it does with unprotected worksheets (i.e., and allow me
to modify the cell's existing information). I've done a lot of testing on
this, including on other machines, even other versions (2000 and 2002). Is
this really an "undocumented feature" or am I losing my mind?


--

Dave Peterson

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
Tabbing through Unlocked cells Susan Excel Worksheet Functions 0 March 27th 06 12:51 AM
How to allow all users to make changes to unlocked cells on WrkSh Arun Excel Discussion (Misc queries) 2 March 19th 06 06:39 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
How can I merge unlocked cells in a worksheet that has been protec NeedMergeHelp Excel Discussion (Misc queries) 2 December 7th 04 02:20 AM


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