View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HagridC HagridC is offline
external usenet poster
 
Posts: 4
Default 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