Is there a macro that insert a new sheet and then ask me to name it.

[gareth7412]

Hi

Im trying to do a macro but donno where to start as I only know how to record macros and not write them.

Im trying to get a macro that inserts a new sheet in the workbook and asks me to name the sheet and that changes the name on the tab.

Can this be done?

Thanks

[carlmon]

Please Login or Register  to view this content.

[mjr veverka]

Please Login or Register  to view this content.

[gareth7412]

Many Thanks