Wish to have a macro that renames the current open tab

Wish to have a macro that can rename a new worksheet tab with the date that it is created such as the now() in excel.

here you go

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Hi -

In Thisworkbook Module, try something like;

Please Login or Register  to view this content.

Regards,
event