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
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
Bookmarks