I have a spreadsheet containing 10 columns with specific data in each row. The spreadsheet will be protected except for one column where it is setup to allow a user to make comments. One of the columns contains the intials of employees as I want the user to beable to use the auto filter on this column allowing them to work on the records that pertain to them only. The problem when I protect the sheet the auto filter goes away. This is the case as well, when I don't protect this column. Any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Auto Filter
- Thread starter mjmoon
- Start date
sweater_vests_rock
Well-known Member
- Joined
- Oct 8, 2004
- Messages
- 1,657
hi mj.
when you protect your sheet, be sure to allow users to use the autofilter. you can do this by checking the appropriate box in the Protect Sheet dialog.
cheers. ben.
when you protect your sheet, be sure to allow users to use the autofilter. you can do this by checking the appropriate box in the Protect Sheet dialog.
cheers. ben.
Upvote
0
Similar threads
- Question
- Question
