Macros
a few assumptions here...
the protected data is contiguous - i.e. the blank rows come at the end not
in between.. if this is the case then the following will help
insert a range like below. the example uses Sheet1 and the protected columns
will be H & I & J. This range expands as data is inserted into column H.
=OFFSET(Sheet1!$H$1,0,0,COUNTA(Sheet1!$H:$H),3)
unprotect all the cells on the sheet
give the sheet a password - in the example it is "mypassword"
insert the following code in a module - it runs each time the sheet is
opened and protects all the data in the range - in this case data in columns
H, I and J
the rows below the last entry in column H are unprotected.
sub Auto_Open ( )
ActiveSheet.unprotect Password:="mypassword"
Range("myrange").Select
Selection.Locked = True
ActiveSheet.protect Password:="mypassword"
end sub
have fun...
"Liz" wrote:
Hi I am trying to set up protection in a worksheet for certain columns only.
On blank rows I would like to add information in those protected columns is
this possible to do with out entering a password. Would I have to create a
Macro for this set up if so how would I go about this. Thanks for any help
you can give me.
|