Warning Message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bollard - 12 Sep 2007 13:58 GMT

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.

Reply to this Message

PCLIVE - 12 Sep 2007 14:42 GMT

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

> We have a spreadsheet with various details relating to a person whose name
> in
[quoted text clipped - 6 lines]
>
> Thank you.

Reply to this Message

bollard - 12 Sep 2007 15:00 GMT

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.

> 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
[quoted text clipped - 13 lines]
> >
> > Thank you.

Reply to this Message

Bernard Liengme - 12 Sep 2007 14:44 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> We have a spreadsheet with various details relating to a person whose name
> in
[quoted text clipped - 6 lines]
>
> Thank you.

Reply to this Message

bollard - 12 Sep 2007 15:02 GMT

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?

> The simplest way would be to:
> 1) Select all the cells (click the square in top left of worksheet window
[quoted text clipped - 17 lines]
> >
> > Thank you.

Reply to this Message

bollard - 12 Sep 2007 15:06 GMT

Hi again

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

> The simplest way would be to:
> 1) Select all the cells (click the square in top left of worksheet window
[quoted text clipped - 17 lines]
> >
> > Thank you.

Reply to this Message

Bernard Liengme - 12 Sep 2007 17:59 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi again
>
[quoted text clipped - 25 lines]
>> >
>> > Thank you.

Reply to this Message