If you're using xl2002+, you can choose to format columns or rows in the
tools|protect|protect sheet dialog.
If you're using xl2k or below, maybe you could provide a macro that would
unprotect the sheet, hide the row and then reprotect the sheet.
guilf wrote:
I have a workbook with a number of worksheets that all interlink.
I have protected a number of cells in one of the sheets.
the problem arrises in that the unprotected cells cannot be hidden or
indeed unhidden when the sheet is protected. Is there a way I can
protect cells whilst still keeping the formatting ability to widen /
hide rows etc.
thanks
--
guilf
------------------------------------------------------------------------
guilf's Profile: http://www.excelforum.com/member.php...o&userid=25608
View this thread: http://www.excelforum.com/showthread...hreadid=390226
--
Dave Peterson