And there's a difference between the properties for one worksheet and a group of
worksheets.

Why? Heck if I know!



"Jonsson " wrote:

Hi,

What I understand the suggested code loops through all the sheets in
the workbook and hide them all.

What I need to do is select about 50 sheets from a wb that contains a
total of 200 sheets. The code I recorded works great as long I choose
"ActiveWindow. Select. Visible= False or xlSheetHidden"

What I can't understand is why the code failure when changing to
"xlSheetVeryHidden".

Any ideas?

//Thomas

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson