About Us

TommyD

Hi, please let me add, I have found this code every where, but I need a code that will keep work each time the work book is opened. Thanks for any help!

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

Quote:

Originally Posted by TommyD

Hi all,
I have a question. I am trying to format a new spreadsheet we will be sending out to our distributors. Needless to say we need to protect the sheet. There are some editable ranges. bur, I also have some grouping done on some of the columns. I'm getting an error message that grouping will not work with the sheet protected. is there anyway of making this work. Version is Excel 2003...

Thanks and...

Jesus alone can save from sin!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell Protection vs. Worksheet Protection	kmwhitt	Excel Discussion (Misc queries)	4	September 24th 06 02:37 AM
Protection & Grouping	ALK	Excel Discussion (Misc queries)	0	May 4th 06 02:45 PM
Worksheet protection is gone and only wokbook protection can be se	Eric C.	Excel Discussion (Misc queries)	4	May 2nd 06 04:50 PM
Sheet Protection - Grouping	carlyman	Excel Discussion (Misc queries)	3	September 22nd 05 11:43 PM
Excel grouping & protection	Smokey Mike	Setting up and Configuration of Excel	1	February 12th 05 03:31 AM

Menu

About Us