It sounds like Protect Sheet (in the Tools menu) might give you what you
want.
It may depend upon which version of XL that you're using, but mine can
prevent users from inserting or deleting rows or columns.

Rgds,
ScottO

"mac_excel" wrote
in message ...
|
| Hi,
|
| I want display message box when the user inserts or deletes a column in
| excel worksheet.
|
| Actually, the worksheet format is fixed and I want to prohibit the user
| from changing the fixed format. Hence, if the user deletes or inserts a
| new column in worksheet, i want to prompt the user.
|
| As far as i know, there is only Sheet_Change Event available for a
| sheet.
|
| Appreciate your help,
|
| regards,
|
| mac
|
|
| --
| mac_excel
| ------------------------------------------------------------------------
| mac_excel's Profile:
http://www.excelforum.com/member.php...o&userid=24983
| View this thread: http://www.excelforum.com/showthread...hreadid=385154
|