How to Control the userForms and their Comand Button

[Patnaik]

Hello Sir,

in my last post i was asked to Mr. stojk89 sir to create / insert a new sheet automatically when i enter the name in Listed range

He explained me with beautiful solutions and with good example work book

the code is

Please Login or Register  to view this content.

Which base sheet is coping for new sheet, in the base sheet i insert the array formula

when i insert a new name in list then the sheet is copied and pasted in with inserted name

when i protect the base sheet then it will working but the formulas are not working it's coping as like text of the base sheet

so how can i copy the base sheet with formulas when the sheet is protected

if possible Kindly suggest

With Regards

Patnaik

[stojko89]

Please use CODE tags for inserting Codes
This part of code needs to be changed:
From

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[Cutter]

@ Patnaik

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[Patnaik]

Hello Sir,

thanks for your valuable MSG

Sir, actually on that post i don't have an idea but after all about my codes i did as per your direction

Thanking You

With Regards

Patnaik

[stojko89]

Patnaik if you ar satisfied with the answer that you were given and your problem is solved then please mark this thread as [SOLVED]
First post select thread tools / and mark this thread as SOLVED.

Also don't forget to thank the user that helped you by clicking the * under his post.