New Worksheets created but hidden

[DarrylBurge]

I have a workbook with Code and Macros applied to track Staff Absence.

When I use Sheet 1 to create a new user, if the last action I did was to hide a user, the new user is created, but hidden.
If the last action i did was to unhide a user, the new user is created and NOT hidden.

Is there any way to make any user created NOT hidden, as these users are just colleagues that need to be tracked, but not shown publicly.

TIA

[Greg M]

Hi there,

It seems (to me anyway!) that instead of inserting a new worksheet after ALL of the worksheets in the workbook, the new worksheet is inserted after the last VISIBLE worksheet.

The renaming operation is performed on the actual last worksheet (which is hidden) - this would explain why the newly-inserted worksheet is not named as required.

See if the following modification of your code cures the problem:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[DarrylBurge]

Perfick

Thank you so much

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M