Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protected Sheet Message | Excel Discussion (Misc queries) | |||
Applying autofilter to protected sheet | Excel Discussion (Misc queries) | |||
How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Unlock a spinner or scrollbar on a protected sheet | Excel Worksheet Functions |