On Apr 25, 11:37 am, Dave Peterson wrote:
I'm confused.

If the sheet was protected, then it was protected to allow you to use the
Outlining feature on that protected sheet.

If the sheet was not protected, then it didn't do anything special--because you
didn't need anything special done to the sheet.

Isn't that what you wanted?



mjones wrote:

<<snipped

Hi Dave, Yes, that is correct. The code is good, but should not
change whether the worksheets are protected or not when the file is
opened. I think you need to finish the code, right?

DaddyO, This code is necessary when outline (groups) are used because
what you say would normally work except with groups.

Thanks,

Michele

--

Dave Peterson

Hi Dave,

I'm a bit confused about what you're confused about. Here's what I'm
doing and I hope it answers your question.

The worksheets (with lots of groups) have two uses. At first, they're
used to estimate project budgets so they're unprotected while
estimates are being entered. Then secondly, after the project budget
has been approved (by the government), budget fields cannot be updated
anymore and the 'government' will password protect the worksheets (I
wish I knew how to do them all at once ... but that's another story).
After that, project managers keep updating the spreadsheet 'actual'
fields for up to four years depending upon the length of the project.
All the fields are unlocked except the budget fields.

What is going on now, is that unprotected worksheets are getting
protected whenever I open the file. The protection status should not
change when opening the file; it should be what it was when closed
(unprotected for unapproved budget or protected for approved budget).

I hope that helps and thanks for your response. I notice how many
people you help on this site and I'm sure we all are glad you're out
there,

Michele