Sheets(1).visible=False not working.

[esbenhaugaard]

I have made an longer Workbook_Open code and in the end of that code I have asked the code to make some sheets not visible (sheets(1).visible=false), but it doesn't work and they remain unhidden. WHY?

Is it because I have uset select or activate earlier in the code?

[HaHoBe]

Hi, esbenhaugaard,

if tested on it´s own the command runs fine (although I would recommend using either xlSheetVisible, xlSheetHidden or xlSheetVeryHidden). Maybe you can post the code or supply a workbook as a sample to have a more detailed look at the code and maybe find out why the line fails (no protection for the structure of the workbook?).

Ciao,
Holger

[esbenhaugaard]

Hey. Thanks for the reply. I will look upon the opportunity to use xlSheetVisible etc. I am quite new to VBA and I discover new opportunities every time, thanks.
I have attached my workbook here. The Workbook_Open is placed in ThisWorkbook.

As you probably can see, I have used some ‘Export K’ to folder which of cause doesn’t run smooth on your computer 

[esbenhaugaard]

I have found the mistake. I have made and Exit sub earlier!!! Big mistake. hihi. Why is there an advantage by using xlsheetVisible?

[HaHoBe]

Hi, esbenhaugaard,

let´s start with a more general remark. You dimmed

Please Login or Register  to view this content.

Except f1 (Single), Rng (Range), oCell (Range), and LR (Long) all other variables on that line are of type Variant. It´s no great point but I like to know of which Type my Variables are, and I like them to give me a hint on which object they will be needed (I can figure that out for Rng, oCel and LR but not for the rest).

Later on in the code you set x to the Monthname of the actual date

Please Login or Register  to view this content.

You could use the Format-Command for that as well:

Please Login or Register  to view this content.

Okay, the computer I work on doesn´t have a drive D so a lot of errors came up in the next part regarding the pictures so I commented a lot of that code.

Setting the Date on Sheet Karrusel:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Why is there an advantage by using xlsheetVisible?

True and False combine for 2 states but using the constants gives you a third one which can only be made visible via VBA-Code or from the VBE. That´s just a matter of taste.

Sorry for my late answer as I have started this post a very long time ago before you actually have found the error yourself (it´s a lot of code to look at ).

Ciao,
Holger