ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting different parts of a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/138892-protecting-different-parts-worksheet.html)

James O[_2_]

Protecting different parts of a worksheet
 
I was wondering if there was a way to protect part of a worksheet with one
question and another part with a different password. I am using Excel 2002.
Your help would be appreciated. Thanks

Bob Umlas

Protecting different parts of a worksheet
 
Try Tools/Protection/Allow users to Edit Ranges (I no longer have 2002, but
it's in 2003 and I think 2002 as well).
Bob Umlas

"James O" wrote in message
...
I was wondering if there was a way to protect part of a worksheet with one
question and another part with a different password. I am using Excel

2002.
Your help would be appreciated. Thanks





All times are GMT +1. The time now is 09:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com