Duplicating a worksheet macro

[awakening1]

Hi, I am using a macro to duplicate a macro but it seems to come up with an Run time 32089 error. This is the code I am using, can someone spot what may wrong:

Sub Newtab()

'Copies sheet and makes a new tab
'ActiveSheet.Copy Before:=Sheets("DO NOT DELETE")
ActiveSheet.Copy After:=ActiveSheet

'Names the new sheet
ActiveSheet.Name = InputBox("Name the worksheet!! Day #. Make sure that there is a space between the word (Day) and its number!!")

 

[awakening1]

Hi, I am using a macro to duplicate a macro but it seems to come up with an Run time 32089 error. This is the code I am using, can someone spot what may wrong:

It used to work before, not quite sure why it is not working now

 

[ScottR]

Are there Active X controls in your workbook? MS have "introduced some issues" with respect to these and yours sounds similar to others I've heard about.

You could try following suggestions in the answers to this query https://answers.microsoft.com/en-us...trols-in/e11f78c5-183c-4930-a35c-74a9abdc9493