| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Disable Adding or Deleting Rows and Columns
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? |
|
#2
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Increment columns in rows | Excel Discussion (Misc queries) | |||
| The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) | |||
| Removing unused or blank rows and columns | Excel Discussion (Misc queries) | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
Linear Mode
