Hi,

I have managed to keep groups available for opening och closing meanwhile one sheet is protected, but when I want this to hold for all sheets in a workbook it won't work. Is there anyone whos has a solution for this and suitable VBA-code that allows opening/closing of groups in all sheets(whole workbook) while all the sheets are protected?

Greatful for all possible help.

BR/Daniel

ps

If you don't have a code for the whole procedure I am thankful for programming code that indicates that some procedure (for example mine above) will hold for all sheets, that is, makes Excel understand that whole workbook should be included.

ds