Using Group/Outline on a Protected Sheet
Using Group/Outline on a Protected Sheet
(OP)
Using Excel 2003, how can you use the Group and Outline functionality on a protected sheet? I have "hidden" some information using Group and Outline, but have also protected the sheet to protect some formulae. When protecting the sheet, I have allowed the users to:
- Select locked cells
- Select unlocked cells
- Format cells
- Format columns
- Format rows
- Use AutoFilter
Actually, I really don't want the users to be formating anything. They should only go in, modify specific cells, Hide/Unhide predetermined columns, and be able to select/copy all the cells values (not the formulae).
Thanks in advance!
- Select locked cells
- Select unlocked cells
- Format cells
- Format columns
- Format rows
- Use AutoFilter
Actually, I really don't want the users to be formating anything. They should only go in, modify specific cells, Hide/Unhide predetermined columns, and be able to select/copy all the cells values (not the formulae).
Thanks in advance!





RE: Using Group/Outline on a Protected Sheet
CODE
You can loop through the Sheets collection using Lbound/Ubound or using the Count property, or using the For Each construct
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk