problem with hidden worksheet

[damrus]

Hi,

I have problem with making sheets visible. I can't see them in Excel, but in VBAProject there are exist. When I try to change status for xlsheetvisible (in properties) I get message:
Setting properties is not possible...

 

[SkipVought]

Hi,

Please explain

1. what sheets are visible

2. which sheet's visible property you are trying to change FROM what TO what.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[damrus]

In properties window in VBA "sheet1" has status:
Visible 0 xlSheetHidden
And I want to get status:
Visible -1 xlSheetVisible

If I want to change it I get the messagage that it's not possible.
I think it might be a protection for it.

So as result "sheet1" is not visible from Excel Application, but is visible in VBA.

 

[combo]

Check workbook's protection. This can happen if the structure protection is on.

combo

 

[SkipVought]

Are you absolutely sure that you are not assigning the xlsheethidden property to the only visible sheet? Excel's message in this case is,

"Unable to set the Visible property of the Worksheet class."

What version are you running?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]