Protect data being pasted over protected cells

Derek · May 16th, 2002, 07:52 PM

Hi Everyone.
Please can someone tell me what is wrong here.
I have a protected worksheet in Excel2000. When I run it on a computer with NT4 it will not allow you to paste over the protected cells. When I run it on a computer with Windows 2000 the identical sheet allows you to paste over protected cells (but it doesn't allow typed entries). Protection settings are identical in both cases.
What do I need to do to prevent a user pasting over the protected cells?
Thanks in advance
regards
Derek

stevebausch · May 16th, 2002, 07:58 PM

My only (wild) guess would be the level of Service Pack for NT, and whether or not SR2 has been applied to Excel.

It IS Excel 97, right?

OOPs, re-read your post, the problem is in 2000-2002.

Check the levels of protection, there is a whole laundry list of protections to be checked.

Go to Tools-Protection-Protect Sheet, and make your choices. See if that helps.

[ This Message was edited by: stevebausch on 2002-05-16 19:01 ]

Derek · May 16th, 2002, 08:03 PM

Hi Stevebausch

No, its Excel2000 in both cases but the spreadsheet was produced in NT4 where it works perfectly. Same sheet under Windows2000 is allowing you to paste over protected cells.
Anyone else had similar problem?

Regards
Derek

stevebausch · May 16th, 2002, 08:05 PM

Try this:

sheet1.EnableSelection=xlUnlockedCells

They won't be able to select a locked cell, if they can't select the cell, they can't paste into it.

This can effectively disable setting the print area, if the top left cell is locked, a outer column is locked, etc.

Be careful.

stevebausch · May 16th, 2002, 08:10 PM

Are you SURE the sheet is protected? I have been playing around in 2002, and it works as you expect.

You might want to visit Office Updates, perhaps there is a fix.

Derek · May 16th, 2002, 08:29 PM

Yes it is definately protected and cells definately locked.
I will try your other idea. Do I put that in an event macro?
regards
Derek

Derek · May 16th, 2002, 08:49 PM

Yes this seems to work fine in an event macro and will solve my problem. Very many thanks for your help.
Regards
Derek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 07:52 PM	#1
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Everyone. Please can someone tell me what is wrong here. I have a protected worksheet in Excel2000. When I run it on a computer with NT4 it will not allow you to paste over the protected cells. When I run it on a computer with Windows 2000 the identical sheet allows you to paste over protected cells (but it doesn't allow typed entries). Protection settings are identical in both cases. What do I need to do to prevent a user pasting over the protected cells? Thanks in advance regards Derek

May 16th, 2002, 07:58 PM	#2
stevebausch Board Regular Join Date: May 2002 Posts: 809	My only (wild) guess would be the level of Service Pack for NT, and whether or not SR2 has been applied to Excel. It IS Excel 97, right? OOPs, re-read your post, the problem is in 2000-2002. Check the levels of protection, there is a whole laundry list of protections to be checked. Go to Tools-Protection-Protect Sheet, and make your choices. See if that helps. [ This Message was edited by: stevebausch on 2002-05-16 19:01 ]

May 16th, 2002, 08:03 PM	#3
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Stevebausch No, its Excel2000 in both cases but the spreadsheet was produced in NT4 where it works perfectly. Same sheet under Windows2000 is allowing you to paste over protected cells. Anyone else had similar problem? Regards Derek

May 16th, 2002, 08:05 PM	#4
stevebausch Board Regular Join Date: May 2002 Posts: 809	Try this: sheet1.EnableSelection=xlUnlockedCells They won't be able to select a locked cell, if they can't select the cell, they can't paste into it. This can effectively disable setting the print area, if the top left cell is locked, a outer column is locked, etc. Be careful.

May 16th, 2002, 08:10 PM	#5
stevebausch Board Regular Join Date: May 2002 Posts: 809	Are you SURE the sheet is protected? I have been playing around in 2002, and it works as you expect. You might want to visit Office Updates, perhaps there is a fix.

May 16th, 2002, 08:29 PM	#6
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Yes it is definately protected and cells definately locked. I will try your other idea. Do I put that in an event macro? regards Derek

May 16th, 2002, 08:49 PM	#7
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Yes this seems to work fine in an event macro and will solve my problem. Very many thanks for your help. Regards Derek