Help Grouping Worksheets In A Workbook !!

[andycov]

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

[soybean]

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?

[andycov]

Hi !

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

Thanks

[soybean]

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.

[andycov]

ok soybean thanks, had a horrible feeling that would be the case !!