Rename sheets VBA Code

[AVG123]

Hello friends..........
I am in a problem i have a workbook and it contains huge sheets and Master sheet is the main sheet..........
Data Sheet contains two button i.e. Commandbutton1 and Commandbutton2

1. i want a code which will rename all sheets with the name of "Form" except "Master, Data, Summary and FormulaCheck"
thats it

2. Here i want again rename all sheets but at this time All sheet's Col-D5 have a number or text i want when i click on Commandbutton2 it replace all sheets name which already have name Form to Col-D5's value..............except "Master, Data, Summary and FormulaCheck"

thats it

[macropod]

For (1), try:

Please Login or Register  to view this content.

For (2), try:

Please Login or Register  to view this content.

Do be aware you can only have one sheet with a given name.

[AVG123]

Thankyou sir it is working flawless...........