Protecting only Hidden Rows on a Spreadsheet
Is it possible to hide several rows on a spreadsheet and protect them from
being 'unhidden' while still allowing another user to edit data elsewhere on the spreadsheet? This spreadsheet will be posted on a shared server for data input by several people but only some of them will be allowed to view the 'hidden' rows. Thank you. |
Protecting only Hidden Rows on a Spreadsheet
Select all cells and FormatCellsProtection. Ensure the "Locked" option is
cleared/disabled. Select the rows to hide then FormatCellsProtection. Make sure the Locked option is enabled. With those rows still selected FomatRowHide. Now protect the sheet with a password which by the way can be easily cracked. Gord Dibben MS Excel MVP On Tue, 2 Oct 2007 12:47:00 -0700, Kathleen wrote: Is it possible to hide several rows on a spreadsheet and protect them from being 'unhidden' while still allowing another user to edit data elsewhere on the spreadsheet? This spreadsheet will be posted on a shared server for data input by several people but only some of them will be allowed to view the 'hidden' rows. Thank you. |
All times are GMT +1. The time now is 01:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com