Using Custom Views in a protected worksheet

Giganews Newsgroups
Subject: Using Custom Views in a protected worksheet
Posted by:  Pierre
Date: Wed, 1 Aug 2007

I want to use custom views for entering data and then printing it...

Not being the one doing the actual entering of the data, I don't want people
to inadvertantly delete colums or other info, so I need to protect the
worksheet.

My different views consist of some colums being hidden for data entry, and
then revealed for printing... but I haven't been able to make this work with
the worksheet being protected... no matter what options I check or uncheck
while protecting the sheet.

Any ideas..?

Thanks!
Pierre, Montreal

Replies