Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected Sheets | Excel Worksheet Functions | |||
protected sheets | Excel Worksheet Functions | |||
Protected Sheets | Excel Discussion (Misc queries) | |||
Protected sheets | Excel Worksheet Functions | |||
Protected sheets | Excel Worksheet Functions |