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.

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


--

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

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.

"PCLIVE" wrote:

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


--

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

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.

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?

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

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.

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.