Sorry, I'm no good at macros (or much else :).
Can someone else help please ...
ScottO


"mac_excel" wrote
in message ...
|
| Hi ScottO,
|
| Thanks for the immediate reply!
| Sorry, I could not convey it properly.
|
| Here i go....
|
| I have defined two columns, (B and C) in an excel sheet.
| I want user to enter values only in these two columns.
| I dont want the user to insert a new column in between B and C using
| the menu Insert-Row (or right clicking on the column C)
| (Thats what ment by saying the format is fixed.)
|
| In "Sheet_Change" event, I can write a message (msbbox "change event is
| called") which will appear when any cell value is changed in the sheet.
| That is how the change event of a cell can be trapped.
|
| Similarly, i want to show a message box when the user inserts/deletes a
| row or a column in a sheet. Where should I write code? Which event
| should I use? (IN EXCEL VBA CODE)
|
| 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
|