LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Protect sheet while enabling outlines and custom views

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I protect/lock columns AND set custom views? Meltad Excel Discussion (Misc queries) 0 July 31st 06 04:03 PM
how do I protect cells in custom views? Tom Clement Excel Discussion (Misc queries) 0 December 16th 05 08:48 PM
Custom views, filters sensitive, in a share workbook an protect sh Andre Fernandes New Users to Excel 0 October 31st 05 09:36 PM
PROTECT SHEET AND SEE MY CUSTOM VIEWS LIVE SANDY Excel Worksheet Functions 0 September 21st 05 11:44 PM
How to password protect hidden columns and custom views in Excel blade444 Excel Discussion (Misc queries) 2 July 29th 05 01:36 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"