VBA/macro to unhide a sheet?

Hi everyone here,

I'm having a challenge with a spreadsheet that puzzles me:

I'm using this quite simple code to hide one of the spreadsheets (named "Ark2"). It written directly in a module as a subprocedure and there's no more code than this:

-------------

Please Login or Register  to view this content.

-------------

The MsgBox "Object library invalid or contains references to object definitions that could not be found" pops up.... Any idea what can be wrong?? Also I can't record a macro that hides or makes the sheet visible ...

When I do the same in another (new) spreadsheet it works???

Help appreciated

Best regards,

Jesper

I've edited your post to add code tags. Please edit it yourself to see how, and use them in the future.

Please Login or Register  to view this content.

The code is even simpler than you think

Please Login or Register  to view this content.

Any reason why you are going through the vbe object to hide stuff?

If the code is in the same workbook as the one with the sheet that needs hiding how about,

Please Login or Register  to view this content.

The macro will probably work if you hide the sheet using menus in Excel rather than by setting project properties in the VBE