Unable to set the visible property of the worksheet class

**colinnwn** · 01-06-2009, 07:50 PM

Hi All,

I've been using the following code successfully for years. Today I would get the error 1004:Unable to set the visible property of the worksheet class. All my searches came up with someone not realizing they had protected the workbook. As you can see, the first thing I do before trying to set the worksheet visible is to unprotect the workbook. In frustration and on a lark I tried .Sheets("items").Visible = True and it worked. These kind of intermittent errors in Excel VBA are very frustrating. Can anyone tell me what I am doing wrong?

Thanks.

Please Login or Register  to view this content.

**Leith Ross** · 01-06-2009, 08:05 PM

Hello colinnwn,

I am not sure what your question is. I can tell you that the Excel constant xlVisible is equal to -1. The boolean value True also equals -1. So in this case, it doesn't matter which one use.

Sincerely,
Leith Ross

**shg** · 01-06-2009, 08:06 PM

The property you want is Hidden, not Visible, and its enumerations are xlSheetVisible, xlSheetHidden, and xlSheetVeryHidden.

Edit:

xlVisible = 12, not 1.

xlSheetVisible = 12

**Andy Pope** · 01-07-2009, 10:00 AM

my object browser says

xlVisible = 12
xlSheetVisible = -1

**romperstomper** · 01-07-2009, 10:12 AM

Originally Posted by shg

The property you want is Hidden, not Visible

The Worksheet class does not have a Hidden property, but does have a Visible one. The problem is just the constant, unless I'm going nuts (again).

**colinnwn** · 01-09-2009, 03:34 PM

Thanks romperstomper, that makes more sense. I knew the visible property worked previously. I don't remember changing the code to xlvisible vs. xlsheetvisible, but the fact xlsheetvisible enumerates to the same thing that ended up working for me (true), is rational.