Message on a cell protected

  • Thread starter Thread starter patrick924
  • Start date Start date
P

patrick924

Hi,
Sorry for my english, i'm french.

Somebody know how can i change the message display when i try to change the
value of a protected cell ?

Thank's for all.
Patrick
 
If it's ok to stop the user from selecting any locked cells, then you could have
a macro in a General module that protects the worksheet with restrictions on
selection (like the option in xl2002).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Unprotect Password:="hi"
.EnableSelection = xlUnlockedCells
.Protect Password:="hi"
End With
End Sub
 

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

Back
Top