Protect worksheet but expand and collapse outline?

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?
 
J

Jim Thomlinson

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

Create form with checkbox les that expand and collapse sections of the form? 0
Group and Outline on a Protected Sheet 13
How 2 do expand/collapse Groupped Columns after worksheet protecti 1
Cannot expand/collapse outline groups on protected sheet 2
Subtotal error to expand Outline Levels 1
cannot expand outline on protected sheet 2
Outlining on a protected spreadsheet 1
Sheet protection and "Group and Outline" 8

Top