Rename Sheets On The Fly With A Drop List- Just Amazing!! Excel In A Capsule (Episode 17)

[@mohammadmohammad-yv4md]

Superb Nabeel Morad

[@Officeinstructor]

Thank you Mohammad...Happy Ramadan

[@mohammadmohammad-yv4md]

@@Officeinstructor Happy Ramadan to you too.

[@sasavienne]

شكرا جريلا لك.. Many thanks Nabil. Stay safe. Best regards Salim

[@Officeinstructor]

Thank you my Friend... The Best Is Yet To Come

[@IvanCortinas_ES]

Your videos are fantastic. Very funny the "moment of truth". Thank you Nabil.

[@Officeinstructor]

"Boom"... The Best Is Yet To Come

[@Saad.PS2009]

عمل في قمة الروعة والجمال إبداع تسلم استاذ نبيل

[@Officeinstructor]

Habibi Shokran Gazilan

[@quasardementor8434]

Smart for my thank you

[@Officeinstructor]

Glad you liked it

[@saleembukhsh7682]

amazing

[@Officeinstructor]

Thank You

[@emile1661]

Looking good... but is it, from there on, impossible for users to change the sheetname with a right click to a name whatever they like?

[@Officeinstructor]

of course Right Click and Rename works as usual

[@santoshrana62]

Amusing - however is this just applicable changing name on one sheet or multiple sheets?

[@Officeinstructor]

We can extend the functionality to other sheets as well with a different code.

[@h.1899]

Hi one question why do we need an if statement over. Can this not work with just the set target = range ("A1")?

[@Officeinstructor]

That's your homework... Try it and get back to me with an answer

[@h.1899]

Tried it now I get why you used it :-)

[@SamehRSameh]

When i chosse the name from A1, change name of sheet or choose the sheet that name in cell A1 ???????

[@Officeinstructor]

Correct

[@zaighamuddinfarooqui1705]

👍👍👍

[@Officeinstructor]

🎁🎁🎁

[@mohammadmohammad-yv4md]

Nabil like to see something on AI embeded in excel plz

[@Officeinstructor]

The Best Is Yet To Come