LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
dwsmha
 
Posts: n/a
Default How do I protect sheet, but allow "group" function to work


Hello, I have a spreadsheet with multiple sheets, and want to prevent
people from seeing my formulas by protected the sheets. However, I have
data "grouped." If I protect the sheet, people can't click on the "+" to
expand groupings. How do I accomplish both?
David


--
dwsmha
------------------------------------------------------------------------
dwsmha's Profile: http://www.excelforum.com/member.php...o&userid=26764
View this thread: http://www.excelforum.com/showthread...hreadid=400174

 
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
Sheet protection and "Group and Outline" OkieViking Excel Discussion (Misc queries) 9 May 22nd 07 05:17 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Protect sheet with outline David Excel Worksheet Functions 1 May 12th 05 12:51 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
Variable validation-password protect sheet Marty Excel Worksheet Functions 0 January 26th 05 02:27 PM


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