enable grouping in protected worksheet

Hi there,

I have created a spread sheet that is to be used as a template for others to upload data into another program. The spread sheet contains a number of mandatory and non-mandatory fields. In order to eliminate erroneous data I have created a series of pull-down lists for the user to select from. In the adjacent cells I have entered a vlookup which returns the actual value which will be uploaded to the other program. In order to keep the spread sheet clean I grouped the non-mandatory columns in one group and the formulas in another group, so only the mandatory fields are visible. I also wanted protect the cells that contained the formulas using the format cells>protection>locked function then 'Protect sheet' function. The problems is I can't expand the non-mandatory columns that have been grouped. Is there anyway to protect the sheet whilst maintaining the group function?

Cheers

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...worksheet.html
Thread Closed.