I need to display a message to a user about adding rows to a worksheet. It
will simply advise them to modify other parameters if a row is inserted. Is
there anyway to do this at the time the user tries to insert?

thanks

Greg

No it is not possible to determine if a row insert is happening
directly
The only option I can think of to store a key value an a very High
rownumber
if the rownumber of this value has been increased a row insert has
happend.
The code to do this should be written either in the workbook or the
specific worksheet.
And it will be iffy and vunerable if someone wants to 'adjust' it.


--
Dnereb


------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=470587