LOGIN Enabled Workbook - Problems Closing one of the sheets

Hello,

I'm trying to close a workbook and using Macros to Loop thru each worksheet to set as xlSheetVeryHidden with the exception of the LOGIN Sheet.

The attached workbook is an .xlsb (recommend changing to.xlsm) file to reduce size. The MACRO operates properly if I'm on the LOGIN sheet (Normally Hidden after logging in). But when I'm on any other sheet and close the workbook I get a Run-time error '1004: Method 'Visible' of object'_Worksheet' failed.

User Name & Password are either:
USER -------- Pword
admin ------- Cville62!!
sorensjp -------- 515457

I cannot understand why every sheet closes properly but Sheet 9 (WEAPS_QUAL_RPT).

Thank you for taking the time to look at this issue and appreciate any advice.

V/r,
Jim

Mumps1,

Thank you. You solved it. I was going to hard code each sheet as to state:

Please Login or Register  to view this content.

vice

Please Login or Register  to view this content.

Does that make any sense?

I just made this minor adjustment to what you wrote and works great:

Please Login or Register  to view this content.

Thank you, again for solving my issue. I was thinking I needed to do way more than just a couple lines.

V/r,
Jim