You certainly can't implement anything like this *without* macros.

Worse, even if you *do* implement it with macros, they are so easy to
bypass, that you should assume that any user with the ability to find
these newsgroups can by pass the protection and read anything in your
workbook.

You would probably be better off to create 9 separate workbooks - eight
1-sheet books, that you can password protect, either via XL (though even
that's pretty easily cracked), or through file permissions, and one
workbook that consolidates the data from each subsidiary workbook.


In article ,
MelB wrote:

How do I do this with password protection? I don't have any experience with
macros yet so I am hoping that isn't necessary for this.