ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protect Excel 2007 but allow ungrouping (https://www.excelbanter.com/excel-discussion-misc-queries/223089-protect-excel-2007-but-allow-ungrouping.html)

PJFry

Protect Excel 2007 but allow ungrouping
 
I have an Excel 2007 workbook that has subgroups. I want to allow others to
view the document and group or ungroup, but not make changes to the document.
When I use Mark as Final or if I protect the workbook or worksheet, they
cannot change anything and they cannot ungroup. Is there a setting that
allows them to manipulate the document, but not be able to save those changes?

Thanks!
PJ


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com