Protect Excel 2007 but allow ungrouping

P

PJFry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking Pages and/or Workbook 1
Embed the same Excel multiple times 0
ASK Field Formatting 1
Integrating information from Word to Excel (not mail merge) 1
modify macro to include more tabs 1
protect worksheet but allow users to use specific columns/cells 1
Word 2016 - Difficulties Learning Style Creation/Application 0
Saving Formulas in Excel 1

Top