Protect data programatically

[Malcom]

Hi all,
I have just joined this NG. I found so may solutions here for my problems
that I feel that no books is required if you read this NG regularly.

My problem:
I have a data sheet which is used by many users for data entry. I want to
protect the data and hide rows from the other users. This must be in such a
way that once the sheet is saved, all the rows having data should be hidden
and any user should not be able to see the data.

I know that before save can be used but I dont know how to make data rows
hidden so that they can not unhide and play with it. Moreover I can not
protect the sheet coz even with the user interface=true causes my other
macros fail.

Since everybody is getting answer, I also expect it even though I am new.

Thanks appreciation of any help.
Malc

 

[Frank Kabel]

Hi
you can add some lines to your macro so you will be able to use sheet
prtection but your macros will still run:
At the beginning of your macros:
Activesheet.unprotect password:= "your password"

at the end of your macro
Activesheet.protect password:= "your password"

 

[Malcom]

I have already tried this but always macro has given unexpected results.
Any other way? Thanks for your reply.
Malc

 

[Frank Kabel]

Hi
what 'unexpected' results. You may post the code of this macro in
question