Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to create a form to input data (either copy and pasted from another
workbook or simply typed in). There will be a range of cells where to enter data (columns A:G) that will be unprotected; the rest of the worksheet will be protected. Is there a sub routine that I could apply in the code window that will allow the user to manipulate the input data in any way other than deleting whole rows, whole columns, or removing cells by cutting them, cutting rows or cutting columns. That way for columns A:G the user could type/paste data, delete or clear contents, but not delete or cut cells/rows/columns such that other cells would shift in the process. Any advice would be greatly appreciated. IP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect Cells After Input - help with macro | Excel Worksheet Functions | |||
How to restrict user to input only one of multiple cells | Excel Worksheet Functions | |||
Searching cells from user input | Excel Discussion (Misc queries) | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel |