Results 1 to 4 of 4

Macro problem X2 on invoice

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2007
    Posts
    54

    Macro problem X2 on invoice

    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.
    Attached Files Attached Files
    Last edited by benswelding; 05-03-2010 at 07:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1