LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Christian Galbavy
 
Posts: n/a
Default grouping of cells in protected sheets

Hy!

I have grouped four rows in my excel sheet. Then I protect the sheet. When I
click on the "-"sign to hide the rows, I get the error message, that this is
not possible in protected sheets. I have written a lot of code, which is
based on protecting and unprotecting my sheets. I also need the grouping
function. Does anybody knows, how I can handle this problem? Is there a
possibilty to allow this function in protected sheets? Are there other
possibilities for the grouping function?
I thank you a lot for any help.

Regards
Christian Galbavy


 
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
Unlocking Cells when a worksheet is protected... racmb1975 Excel Discussion (Misc queries) 2 May 3rd 05 08:57 PM
Auto Skipping and protected cells Dave Peterson Excel Discussion (Misc queries) 6 January 27th 05 11:35 PM
Grouping in protected sheets Maia Excel Discussion (Misc queries) 1 January 3rd 05 04:04 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM


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