Invoice Details Not Saving Properly to Invoice Payments sheet

Hello,

On the Invoice Template sheet there is a shape "Save" to save some invoice details to the Invoice Payments sheet by a macro "SaveAsPDF".

The details sometimes are proper but not always. If I create a new invoice with shape "New" on the Invoice Template and fill in the detail Date, Customer ID, some descriptions and quantities then try to save the invoice it sometimes does weird stuff on the Invoice Payments sheet.

I temporarily disable the part of code that saves the invoice as a PDF file in the onedrive so the code can run for anyone.

Please try to create a few new invoices and see what happens showing it doesn't always fill in the proper details in the Invoice Payments sheet.

Thank you very much for your help

What is happening is sometimes the row of info that is pasted in the table in the Invoice Payments sheet is not correct in the table columns.

The last row shows how it is wrong.

I tried adjusted the code for the offsets but not sure how to fix.

The idea is to paste the Invoice No., Customer (last name), Invoice Date, Invoice Amount, and Hyperlink to the PDF file in the next row of the table on the Invoice Payments sheet.

TO get around saving it more than once a formula pops up on the Invoice Template sheet notifying the invoice was saved.

Perhaps new code to copy and paste to next row in table?

Thank you for your help guys. I applied the individual sheets involved for the code to run unprotect and protect at certain places in the code and it seems to work just fine.

Please Login or Register  to view this content.

Torachan referring to #6 yes the protection is what is interfering with the saving of the invoice. I need to have the protection so the sheets don't get messed up accidentally.

The #8 post shows the code that seems to work but slowly because it is selecting the individual sheets to activate and protect during the code run.

Is there a way to protect the 2 sheets (Invoice Template and Invoice Payments) at the end of the code run but not have them temporarily pop up and slow down the code run?

I am aware when the PDF file is being generated there is a delay but it would be better if the running of the code is faster.

Thank you

Much better thanks TMS it does run faster.

I made the adjustments in the code.

Are there any other improvements to the code that you can recommend?

Please Login or Register  to view this content.

Thanks TMS I added those but when running the code there are other sheets that still partially popup during the code run.

Maybe this is unavoidable not sure.

Torachan,

I understand what you are saying as more data is entered the formulas will slow down the workbook.

This will be a huge undertaking but I am willing to put forth the effort.

But I am not sure where to start.

Any advice would be greatly appreciated.