Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming |