problem using protected sheets
 

So this should be possible in Excel 2003?
Can you tell me how to achieve this?

Regards
Thijs van Bon

"Frank Kabel" schreef in bericht
...
Hi
AFAIK not possible in Excel 97

--
Regards
Frank Kabel
Frankfurt, Germany


ties wrote:
I have the following problem, which I'm not sure is possible to
solve/work around:

In my sheet I grouped several columns and rows. After protecting the
worksheet it's not possible anymore to hide or show the groups, which
I really need to be able to do.

I'm using Excel 97.

Does anyone know a solution or work around?

Thanks in advance
Thijs van Bon

problem using protected sheets
 

I have the following problem, which I'm not sure is possible to solve/work
around:

In my sheet I grouped several columns and rows. After protecting the
worksheet it's not possible anymore to hide or show the groups, which I
really need to be able to do.

I'm using Excel 97.

Does anyone know a solution or work around?

Thanks in advance
Thijs van Bon

problem using protected sheets
 

Hi
AFAIK not possible in Excel 97

--
Regards
Frank Kabel
Frankfurt, Germany


ties wrote:
I have the following problem, which I'm not sure is possible to
solve/work around:

In my sheet I grouped several columns and rows. After protecting the
worksheet it's not possible anymore to hide or show the groups, which
I really need to be able to do.

I'm using Excel 97.

Does anyone know a solution or work around?

Thanks in advance
Thijs van Bon

problem using protected sheets
 

If you already have the outline applied, you can protect the worksheet in code
(auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

It needs to be reset each time you open the workbook. (excel doesn't remember
it after closing the workbook.)

ties wrote:

I have the following problem, which I'm not sure is possible to solve/work
around:

In my sheet I grouped several columns and rows. After protecting the
worksheet it's not possible anymore to hide or show the groups, which I
really need to be able to do.

I'm using Excel 97.

Does anyone know a solution or work around?

Thanks in advance
Thijs van Bon

--

Dave Peterson

problem using protected sheets
 

It is possible in Excel 97 - see Dave Peterson's answer.

--
Regards,
Tom Ogilvy

"ties" wrote in message
...
So this should be possible in Excel 2003?
Can you tell me how to achieve this?

Regards
Thijs van Bon

"Frank Kabel" schreef in bericht
...
Hi
AFAIK not possible in Excel 97

--
Regards
Frank Kabel
Frankfurt, Germany


ties wrote:
I have the following problem, which I'm not sure is possible to
solve/work around:

In my sheet I grouped several columns and rows. After protecting the
worksheet it's not possible anymore to hide or show the groups, which
I really need to be able to do.

I'm using Excel 97.

Does anyone know a solution or work around?

Thanks in advance
Thijs van Bon

problem using protected sheets
 

Hi Dave,

Thanks a lot. I tried it and it seems to work flawlessly. This will save me
a lot of work!

Regards
Thijs


"Dave Peterson" schreef in bericht
...
If you already have the outline applied, you can protect the worksheet in
code
(auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

It needs to be reset each time you open the workbook. (excel doesn't
remember
it after closing the workbook.)

ties wrote:

I have the following problem, which I'm not sure is possible to
solve/work
around:

In my sheet I grouped several columns and rows. After protecting the
worksheet it's not possible anymore to hide or show the groups, which I
really need to be able to do.

I'm using Excel 97.

Does anyone know a solution or work around?

Thanks in advance
Thijs van Bon

--

Dave Peterson