| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking cells automatically after enter
Greetings,
I'm new to writing and using macros and need some help. I have 9 worksheets in a workbook On one of the sheets I have a grid 25 x 25 The worksheet is protected. All cells in the grid are not locked at the present time. What I want to do is have the cell automatically lock after data has been entered. I have been trying with ActiveCell.Locked=TRUE, OnKey.ENTER and other statements in various orders with no success. Could someone please advise. Also, where do I put this macro, in the sheet# or in the module# -- Have a Great Day! HagridC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically move to adjacent cells without hitting Enter | Excel Discussion (Misc queries) | |||
| Enter a number on different cells automatically ? | Excel Worksheet Functions | |||
| want to automatically skip certain cells when you hit enter | Excel Worksheet Functions | |||
| HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS | Excel Worksheet Functions | |||
| set tab or enter keys to automatically move to different cells | Excel Discussion (Misc queries) | |||
Threaded Mode
