Protection Message

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

When a worksheet is protected and a cell is locked then an Error message
appears whenever the user attempts to edit the cell.
Is there an event that I can tap into so that I can display my own message
and run my own routine instead of the standard message?

Thanks for any help
Fred
 
Maybe you could just stop them from selecting locked cells on your worksheet:

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

And xl2002 added the ability to set the enableselection property via the
userinterface.
 
You must log in or register to reply here.

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

Change a default Excel warning 1
How disable an Excel dialog box? 4
Intercept/replace standard 'cell protected' message with my own message? 3
Cell Toolbar Dilemma xl2013 13
Worksheet protection 2
Allow VBA code to change a locked cell?? 2
Select statement or me? 12
Avoid protected cell warning on BeforeDoubleClick WS event 2

Back
Top