AddSheet Calendar Macro Issue

Hello all,
New member with limited vba experience.
I searched a fair bit for a solution but found nothing to point me in the required direction.

The issue: I have a macro to create a new wsheet with a tabname from a cell in a sheet called Data. The cell value (from Data), is a date which is inserted when a date is seleted from a popup calendar.This cell value then names the sheet tab and also appears in cell M1 in the sheet just created.
Now, when I select another date from the calendar (to create a new sheet), the macro works perfectly-(it creates and name the new sheet tab with the new date and copy the new date to M1 in same sheet)...but, any sheets previously created will now change all values in cell M1 to the most recent selected date but all tabnames remain correct?
Required outcome: is for any sheet previously created to have the cell M1 not linked to the calendar somehow...if that makes any sense


thanks

Hello nauti,

Welcome to the Forum!

Here is the revised macro which has been added to the attached workbook.

Please Login or Register  to view this content.

Hello nauti,

I changed the macro to protect the sheet after it has been added. You can set the password to what you like in the code.

Please Login or Register  to view this content.