Sheet Protection

S

seezzell

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

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

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.
 
Top