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
Bookmarks