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