LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chiku
 
Posts: n/a
Default Outlining in Protected Sheet - Attention DP

I have a question about a previous code I saw for maintaining outlines in a
protected worksheet. DP, if you read this, need your help - the code was one
you posted for someone.

Before the code, your wrotes:

If you already have the outline applied, you can protect the worksheet in code
(auto_open/workbook_open??) - What does this mean?

The code is as follows:

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

At the end, you also add that it needs to be reset each time, what too does
that mean?

Two other small questions
1.) - what is the code doing exactly (I just need to understand what it says
in simple terms which helps me understand and change the code if necessary)
2.)And two, everytime I paste it, the "Option Explicit" always pastes
separately. Should I be pasting this under View code on worksheet or
somewhere else? (I admit, my programming knowledge is limited but I can
understand if it's explained)
Thanks in advance.
 
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
Protected Sheet Message tlosgyl3 Excel Discussion (Misc queries) 2 December 8th 05 08:13 AM
Applying autofilter to protected sheet Brian Ferris Excel Discussion (Misc queries) 2 November 18th 05 04:28 PM
How to copy/paste info into the protected sheet Dajana Excel Discussion (Misc queries) 1 September 21st 05 04:26 PM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM
Unlock a spinner or scrollbar on a protected sheet kevin99 Excel Worksheet Functions 1 March 14th 05 01:03 PM


All times are GMT +1. The time now is 04:16 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"