Macro problem X2 on invoice

[benswelding]

I have a timesheet invoice spreatsheet I made with the help of the good people on this site.I have the timesheet and invoice on the same sheet so I can click the copy macro button which copies it,increases the invoice number by 1 and puts it in the same work book together.There is an error however that happens when i copy it more that once.It says (A formula or sheet you want to move or copy contains the name 'day'(day's edays and month also come up if I answer no) and allready exists on destination worksheet and asks me if I want to use this version of the name) I have tried and I cannot figure out what to do about it.I have attached the file in hopes than somebody can help me with this.I also have a macro that I made with te macro recorder that does the following- Unhides my Invoice-selects print area to print-sets to portrait-prints x2 copies-rehides invoice-and then protects it.This works fine but I would like to have it protected before I click the print invoice button to to prevent someone from accidentally deleteing a formula or something.If anybody could or would help me with these two problems I would appreciate it.

[royUK]

Can I suggest that you do some basic reading on working with VBA,either internet, a book or search this forum. You workbook is full of empty modules, this is unnecessary & makes it difficult to locate the specific code you want help with. In looking I see that you haven't used the code that I amended for you yesterday nor bothered about declaring variables. You can't expect us to do everything,show some willingness to learn & follow upon suggestions

Some basic notes in the code would help as well

Please Login or Register  to view this content.

[benswelding]

I did use your code just not on that sheet.I shall do more reading . Thanks for your help.

[royUK]

If you used the code why post an example with redundant code?