View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Amending standard Excel popups

I don't think you can change those messages. But you could stop the users from
selecting a locked cell on a protected worksheet.

Lock all the cells on the worksheet except the cell to edit--keep that unlocked.

(Format|Cells|Protection tab is where you do that work)

Then add a macro that protects the worksheet (nicely) when the workbook opens:

Private Sub Workbook_Open()
With Worksheets("Sheet99999")
.Unprotect Password:="hi"
.EnableSelection = xlUnlockedCells
.Protect Password:="hi", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End With
End Sub

In fact, in xl2k and below, this setting wasn't remembered when you closed the
workbook and reopened. Setting it in code was the only way to do this.

Colin Hayes wrote:

Hi

I have a couple of small queries :

Is it possible to amend the Excel popup which you get when trying to
select a protected cell? Or put another one to run in it's place? I'd
rather have one that says 'This cell cannot be changed' and leave it at
that , than the standard one which suggest digging around trying to find
the password..

Also I was wondering if the selection box in Excel (the one which shows
which cell you are selecting) could be formatted in any way. Maybe a
lighter or thinner border , or different colour...

Any help gratefully received.

Thanks.


--

Dave Peterson