LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Protect woksheet and keep using outline capabilities

Hello,

I need to share a worksheet and protect certain cells (preventing users to
replace formulas by values)
I tried to lock these cells and protect the worksheet.

Problem : when I do so, users can no longer use ouline "+" and "-" icons to
show or hide columns.

Could somebody help me ?

I am using Excel 2003

Many thanks and kind regards

--
Jean-Luc
 
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
protect the worksheet but still can do the "group and outline" dat lalann Excel Discussion (Misc queries) 5 March 18th 09 02:22 PM
Protect worksheet but expand and collapse outline? Trini_Suize Excel Discussion (Misc queries) 1 September 8th 08 11:57 PM
Can I protect an Excel spreadsheet, and use Outline functions? jdmarsh Excel Worksheet Functions 2 June 24th 06 02:29 AM
how to protect excel worksheet and still use the outline buttons? sylvia Excel Worksheet Functions 0 December 6th 05 12:32 PM
Protect sheet with outline David Excel Worksheet Functions 1 May 12th 05 12:51 PM


All times are GMT +1. The time now is 05:24 AM.

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

About Us

"It's about Microsoft Excel"