Home

VBA and hidden worksheets

Frdric
Occasional Visitor

Hi,

 

I have a workbook in Excel which uses VBA code and I have problems with hidden worksheets. 

When I try to make hidden worksheets visible I obtain an error warning : 'feature "visible" of class worksheet can not be put in place' (which is a translation out of Dutch).

 

I'm not the writer of the code and just the user of this workbook, which went well before I bought this new computer with new software ( amongst other: Office 365). 

 

Can anyone help?

 

Thanks in advance

2 Replies
Highlighted

Hi,

 

Try to contact the coder of that VBA code and ask him to fix the error.

It may be a bug or intended for some reasons!

 

Hope that helps

@Haytham Amairah 

The VBA coder would be first choice, assuming they are contactable.  If not, it is possible that others could help provided to OP knows the VBA project and the Workbook structure passwords.  Running the macros with the code window open may well give additional clues.

Related Conversations
sum by color when colors are set by conditional formatting
matt nipper in Excel on
197 Replies
Compile error: Method or data member not found
kevin whiteside in Excel on
5 Replies
Re: Macro to save as PDF with auto filename as cell value
Joe Gray in Excel on
23 Replies
Debug Error on Macro
Greg Bonaparte in Excel on
29 Replies