| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent changes to cells but let user move columns?
Hi,
I have a situation where I would like to control what the user types into cells of a specific column. But at the same time, since I am using a ListObject I would like to let the user move columns around by selecting an entire column and then dragging it another location. I have code in the workbook's sheet_change event. This event is triggerred when a cell is changed or a whole column is moved. Is there a way I can disable the checking of values in cells when a column is being moved? Thanks, Sai |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent user from using Name | Excel Discussion (Misc queries) | |||
| My arrow keys won't move between cells only rows & columns | Excel Discussion (Misc queries) | |||
| Prevent User Seeing Data in Hidden Columns | Excel Discussion (Misc queries) | |||
| Prevent User from saving | Excel Programming | |||
| How do I: prevent user from scolling down and right? | Excel Programming | |||
Threaded Mode
