PDA

View Full Version : Disable Insert/Delete Row/Column



sujittalukde
11-22-2008, 04:01 AM
I want to disable insert/delete Rows/Columns via macro for a particular workbook form any source say Insert menu,right button click, shortcut keys from key boards etc.
How can I do so?
Thanks

MaximS
11-22-2008, 04:15 AM
why not to use Protection for selected Worksheets and tick everything apart form insert column, insert row, delete column, delete row.

Protection is located: Tools >> Protection >> Protect Sheet