I am trying to semi automate the creation on a new worksheet within a
book.

I have recorded a macro which copies a master worksheet.

I would like to offer users a button to initiate the macro and ideally
have the new sheet given a name based on the content of the cell
highlighted when the macro is run.

any ideas?

Ian


--
ihr
------------------------------------------------------------------------
ihr's Profile: http://www.excelforum.com/member.php...o&userid=18944
View this thread: http://www.excelforum.com/showthread...hreadid=508944