complicated hide/unhide rows on protected sheet

Originally Posted by JBeaucaire

Change the macro IN the workbook to the same as the one posted above.

wow, it works!! When i click print i cant select which printer i want to print to or select paper sizes and if i want it in color. any suggestions?