You are going to need some fancy VBA code to capture the fact that a "name"
cell has been selected. Post your question in the programming newsgroup.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"bollard" wrote in message
...
Hi again

Also, I don't want to prevent anyone from deleting a name, just warn them
if
they try to do so.

"Bernard Liengme" wrote:

The simplest way would be to:
1) Select all the cells (click the square in top left of worksheet window
where column and row header meet); use Format Cells and unlock them all
2) Select all the cells with the names (B columns) and with Format Cells,
lock these
3) Use Tool | Protection; protect worksheet. I will leave it to you to
decide it a password is needed.

Now it is impossible to delete or change name until the worksheet is
Unprotected.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"bollard" wrote in message
...
We have a spreadsheet with various details relating to a person whose
name
in
Column B of the sheet.

We want to create a warning message when anyone tries to delete the
name.

Does this require a Macro, or is there any other way to create such a
warning message?

Thank you.