I am trying to write a macro in Excel to manipulate Hidden and Visible worksheets and am running into a problem.  The Help on this subject reads as follows:

       Notes: To select multiple sheets do either of these:

                  Press and hold CTRL, then click the items to select them.

                  Press and hold SHIFT, then use the up and down arrow keys to adjust your selection.

Neither of these options work. 

My goal here is to select all Hidden sheets and make them visible so I can work with them.  Can anyone shed some light on this?

​I am trying to write a macro in Excel to manipulate Hidden and Visible worksheets and am running into a problem.  The Help on this subject reads as follows:       Notes: To select multiple sheets do either of these:                  Press and hold CTRL, then click the items to select them.                  Press and hold SHIFT, then use the up and down arrow keys to adjust your selection.Neither of these options work.  My goal here is to select all Hidden sheets and make them visible so I can work with them.  Can anyone shed some light on this?  Read More

​