p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   Password Protection and Other Items (http://p2p.wrox.com/showthread.php?t=23706)

snoopy92211 January 10th, 2005 05:53 PM

Password Protection and Other Items
Hello All. Here's my issue

I have a spreadsheet, a portion of which is shown below. All of the columns in the worksheet have an auto filter. I want my analysts to be able to filter any and all of the columns. However, I only want them to be able to edit column c. I want Columns A and B to be password protected; because only the administrator of the worksheet should be able to edit these columns. In sum, how can I

1. lock columns a and b, (password protect it for the admin to update these columns)
2. leave c open for editing
3. Have all users filter the rows (but I still want A and B locked).

Keep in mind that the first row has header fields (No, Type and Price respectively)

No. Type Price
11 cat 5.66
23 dog 6.33
35 mouse 8.99
45 rabbit 6.77
5 snake 6.66

Thanks in advance!!


amjad_mahmood January 14th, 2005 02:27 AM

It's possible if you have Excel-2002.

UnLock the cells in column C
Tools->Protection->Protect worksheet---> you check on Allow users to use AutoFilter

All times are GMT -4. The time now is 03:57 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.