Warning Message

B

bollard

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.
 
P

PCLIVE

How is the cell with the Name originally populated? Is it a formula? You
could use sheet protection and leave that cell locked. Will that work for
you?

Regards,
Paul
 
B

Bernard Liengme

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
 
B

bollard

Hello

Names are just input into Column B. I want people to be able to enter a new
name, but warn them if they try to delete one that's already there.
 
B

bollard

Hello Bernard

Many thanks for this.

But will it then be possible to add a new anme in the first blank row of the
worksheet?
 
B

bollard

Hi again

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

Bernard Liengme

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
 
Top