How to make a warning message box "Don't insert line!" ?

[london7871]

As I don't want the users of my excel insert line,
if they insert line, I want a warning message box "Don't insert line!" appeared.
(The actual wording and type of message box will be confirmed myself afterwards)

[mikerickson]

Define a name
Name: Row_1000
RefersTo: Sheet1!$1000:1000

Then put the formula =ROW(Row_1000) in a discreete cell.

Then put this in Sheet1's code module

Please Login or Register  to view this content.

[london7871]

Thanks mikerickson.

[mikerickson]

Actually, that should be in the Calculate event, not the Change event You can use similar code if you want to prevent row deletion.


If you want the user to be able to delete rows, but not insert any, you have to modify that routine a bit.

Please Login or Register  to view this content.

[london7871]

Thanks mikerickson.

Please advise how to "put this(VBA) in Sheet1's code module"?

[mikerickson]

This link explains how
http://www.contextures.com/xlvba01.html

[london7871]

Thanks again mikerickson. I see.