Protect worksheet but expand and collapse outline?

  • Thread starter Thread starter Trini_Suize
  • Start date Start date
T

Trini_Suize

I'm currently using Excel 2003 and building a spreadsheet that has a lot of
columns and formulae. I protected the sheet and unlocked the relevant cells.
However, before protecting the sheet, I also outlined the sheet making it
easy to expand and collapse the relevant months. But when the sheet is
protected, I lose this functionality. Is there any way to protect the sheet
but still allow users to expand and collapse the relevant months?
 
The short answer is no... If you are ok with the macros then it is fairly
easy to get around. You can have a macro that locks the spreadsheet only when
certain areas of the sheet are selected. Otherwise it is unprotected. That is
fairly easy to do...

My preference for such a macros is to protect the sheet whenever the
selected range includes a formula. Otherwise it remains unprotected. In those
cases I just make my headers into formulas to keep them from being
overwritten. That is very easy code to write...
 

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

Group and Outline on a Protected Sheet 14
Outlining on a protected spreadsheet 1
expanding or collapsing groupings in protected worksheets 5
How do I remove the outline protection in Excel sheet? 1
Sheet protection and "Group and Outline" 8
Collapsing all groups 0
Subtotal error to expand Outline Levels 1
How 2 do expand/collapse Groupped Columns after worksheet protecti 1

Back
Top