do away prompt when protected cell is being written

[oldLearner57]

hi community

is there any method to turn off the prompt...." The cell or chart you are
trying to change is protected......" be turned off whenever user wanted to
modify a protected cell.

the xls is 2003

thanks community for the assistance given

 

[JLatham]

I don't think there's really a practical way to just turn off the prompt -
you could turn off prompts when the sheet is selected but you'd not get any
for any other desired operation while
Application.DisplayAlerts = False
was in effect.

Possibly one way to get away from the problem is to change the setup when
protecting the sheet to NOT allow the user to select locked cells. Then
they'll only be able to select cells where their input is expected/accepted.

 

[oldLearner57]

thanks "JLatham" for the replied
& 10s community as well