1.

Solve : Help Grouping Worksheets In A Workbook !!?

Answer»

Hi,

FIRST post for me, hopefully U guys can help me !!

I have a workbook in Excel 2000 which has multiple worksheets in it, some of which need to be grouped. I know how to group the RELEVANT worksheets together but when I click to work on another worksheet it ungroups the others which I don't want it to do. Is there anyway of "locking" the grouped sheets together so they are permanently grouped? Maybe with a PASSWORD protection to ungroup?

Hope this all makes sense, any help would be appreciated !!

THANKS
Quote from: andycov on March 26, 2008, 04:13:24 AM

I know how to group the relevant worksheets together but ...
Let's confirm your technique as a first step in troubleshooting this. Exactly how are you grouping worksheets?Hi !

I do that by pressing the control key on the keyboard then highlighting the relevant worksheets.

Thanks
I'm using Excel 2003. I've searched through the Help FILES and see no way of "locking" the grouped sheets together so they are permanently grouped.ok soybean thanks, had a horrible feeling that would be the case !!


Discussion

No Comment Found

Related InterviewSolutions