G Guest Oct 14, 2005 #1 I'm trying to protect one column in my spreadsheet and still allow my users to hide/unhide columns and sort. Suggestions?
I'm trying to protect one column in my spreadsheet and still allow my users to hide/unhide columns and sort. Suggestions?
R Richard Buttrey Oct 15, 2005 #2 I'm trying to protect one column in my spreadsheet and still allow my users to hide/unhide columns and sort. Suggestions? Click to expand... Once you've protected your s/s I don't believe you can. Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________
I'm trying to protect one column in my spreadsheet and still allow my users to hide/unhide columns and sort. Suggestions? Click to expand... Once you've protected your s/s I don't believe you can. Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________
D Dave Peterson Oct 15, 2005 #3 xl2002+ has this ability--it's on the tools|protection|protect sheet dialog. If you're using xl2k or before, you could provide a macro that unprotected the worksheet, did the work, then reprotected the worksheet.
xl2002+ has this ability--it's on the tools|protection|protect sheet dialog. If you're using xl2k or before, you could provide a macro that unprotected the worksheet, did the work, then reprotected the worksheet.
