How to resolve issue in locked cell for excel spreadsheet

T

Taurus

Hello,

I have this report formatted cells by unchecked Locked under protection
tab.
After this complete, i had the sheet protected with password and only
allow user to change or edit the unlocked cells.

'Protect worksheet
ActiveSheet.Protect Password:="32523*1323*1533*196",
DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells

Issue for this is - It will locked the cells when user copy and paste
from a spreadsheet to the column that is editable. User could not
change the data on the unlocked cell.

Another thing is - It will not locked it if user physically open the
excel file and copy and paste to the cells. User is able to edit the
cells.

Could any one help me out to resolve this issue or any code I should
put to resolve this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect Sheet 2
Issue With Macro Sheduling Using On Time Event 0
Use VB to unlock & lock cell protection 2
how can I lock/unlock a range of cells depending on state of a checkbox? 4
ToggleButton to Unprotect/Protect all worksheets 0
Locked Several Worksheets, allow format cells/select unlocked cell 2
Can't lock cells 4
Strange worksheet protection behavior 5

Top