View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Janice[_2_] Janice[_2_] is offline
external usenet poster
 
Posts: 3
Default Grouping & collasping in a protected worksheet

HELP!

I have created an Excel form and created groups that can
be expanded or collapsed by the user. However, once I
protect the sheet the user is denied access to the +/-
button that will perform the function. I have tried
adding a command button to use as a macro but the macro I
recorded won't perform the expand & collapse feature. Any
one have an alternative method?