Outlining protectd Workbook

chell · Mar 30th, 2004, 01:33 PM

Hi, I need to protect a workbook, so staff can only enter data in certain cells. At the same time I want to set up outlining and let staff use the outlining to collapse and expand the workbook. Once it is locked though, Excel will not let them use outlining anymore.

any suggestions?

jimboy · Mar 30th, 2004, 01:44 PM

Hi, Welcome to the board.

You can do this with this macro, just change the sheet name...

Code:

Sub Outline_Protect()
'Allows Outining while sheet protected

'Change Sheet name (twice)
    Sheet3.EnableOutlining = True
    Sheet3.Protect Contents:=True, UserInterfaceOnly:=True
End Sub

Mar 30th, 2004, 01:33 PM	#1
chell Join Date: Mar 2004 Posts: 1	Outlining protectd Workbook Hi, I need to protect a workbook, so staff can only enter data in certain cells. At the same time I want to set up outlining and let staff use the outlining to collapse and expand the workbook. Once it is locked though, Excel will not let them use outlining anymore. any suggestions?

Mar 30th, 2004, 01:44 PM	#2
jimboy Join Date: Apr 2002 Posts: 2,314	Re: Outlining protectd Workbook Hi, Welcome to the board. You can do this with this macro, just change the sheet name... Code: Sub Outline_Protect() 'Allows Outining while sheet protected 'Change Sheet name (twice) Sheet3.EnableOutlining = True Sheet3.Protect Contents:=True, UserInterfaceOnly:=True End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode