How to NOT show a certain page on start-up

[bonconsul]

Hello,

I have a sheet with login details per user and I as administrator am the only one who can see it. Now if I accidently save the file when I am on that sheet and close the workbook, anyone after that opening the excel will see that sheet while the macro is running to go autoamtically to another welcome sheet.

Is there a way to avoid that the last sheet shown at the moment of save is visible during the opening of the workbook?

Wouter

 

[bobsan42]

hide it before close and save.
And don't show it unless necessary.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    ThisWorkbook.Worksheets("Sheet1").Visible = xlSheetVeryHidden
End Sub

 

[bonconsul]

hide it before close and save.
And don't show it unless necessary.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    ThisWorkbook.Worksheets("Sheet1").Visible = xlSheetVeryHidden
End Sub

Hey Bobsan, thanks a lot!
The thing is that it only works when you also save it at the time you close the workbook. If I saved it before (with the sheet that I want to hide open) and close without saving, it will nowt work.
Perhaps I can do a macro WHILE saving?

 

[bobsan42]

more like BeforeSave:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    ThisWorkbook.Worksheets("Sheet1").Visible = xlSheetVeryHidden
End Sub

 

[bonconsul]

Thank you so much !!