Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I saw several posts outlining how to enable the outline function (Data
.... Group and Outline ... Group). Very helpful. Thanks. Is there some way also to enable custom views which hide certain *sheets* and hide *rows/columns*? I have the following code that runs when the workbook is opened: -------------------------------- Private Sub Workbook_Open() ActiveWorkbook.CustomViews("Navigation").Show MsgBox "Please select the appropriate view on the Navigation tab: summaries on left, working views on right.", vbOKOnly, "[snip name]" End Sub -------------------------------- So, the user interface depends on the use of radio buttons, which in turn call out custom views as such (for example): -------------------------------- Private Sub OptionButton7_Click() ActiveWorkbook.CustomViews("2004 Q1 Full View").Show End Sub -------------------------------- So, if I want both the outline function to work and the custom views to work in a *protected and shared* worksheet, is there any way to do that? Will the ranges I have defined for users to be able to edit still work if protection is invoked from VBA upon workbook open, or will I have to explicitly define editable ranges in the VBA code? Thanks, ... and pardon the long list of questions. Michael Lambert. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I protect/lock columns AND set custom views? | Excel Discussion (Misc queries) | |||
how do I protect cells in custom views? | Excel Discussion (Misc queries) | |||
Custom views, filters sensitive, in a share workbook an protect sh | New Users to Excel | |||
PROTECT SHEET AND SEE MY CUSTOM VIEWS | Excel Worksheet Functions | |||
How to password protect hidden columns and custom views in Excel | Excel Discussion (Misc queries) |