View Single Post
  #1   Report Post  
Jason Morin
 
Posts: n/a
Default

You can put a value in cell IV65536 to prevent the user
from adding rows or columns. Deleting would require some
VBA. MVP John Walkenbach has some here using "undo":

http://j-walk.com/ss/excel/tips/tip23.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there a way to disable a user from adding or deleting

rows and columns but
still be able to enter information and run macros?
.