Business Info Not Copying on Job Sheets Invoice and Proposal

[billy60]

Hi,

Groups 20 and 30 of textboxes aren't being copied to new job sheets with VBA.

On the Admin sheet there is a selected to add new sheets with Job numbers. When I add new sheets for some reason the business addresses (group 20 and 30 of textboxes) aren't showing on the Invoice or Proposal of the Job sheets.

Can someone see why these aren't being copied over?

The Copysheet has the groups which is the source sheet to be copied over.

Thank you

[Logit]

I tried loading your workbook here and received an error message the workbook is corrupt and unable to load.

[billy60]

What can I do?

[billy60]

I closed it then saved a new version.

Does this help?

[Logit]

Still same issue.

I attempted to repair the workbook during the opening process but was unsuccessful.


It is always best to maintain a copy of any workbooks you highly depend upon. When Excel decides to die, having a backup copy is always a life saver.

From personal experience, the only thing you can do now is to re-write the entire workbook from scratch. DO NOT copy and paste because you'll end up
copying and pasting the corrupt portions as well.

[billy60]

Is it possible that since I have 365 it is the issue? I have no issues opening on 3 different computers.

[Logit]

I ran into issues trying to run previously built projects in the 365 environment.

Do a search for Excel 2013 (or whatever version it actually is) won't run in Excel 365. There is a small "trick" Microsoft released that helps.

[billy60]

This was developed in 365 and is what I am using now.

[Logit]

Guess you'll need to re-write the entire workbook.

[billy60]

I unhid all columns on copysheet and then ran the duplicate code.

Now all textbox groups appear.

I will leave all columns on Copysheet unhidden since this seems to fix the issue at hand.

[Logit]

Ok ... you have a start to the issue ... unhiding the columns. Look at the code in that area and see if you can pinpoint
what might be the issue. Is there a line of code the requires the columns to be visible ?

[billy60]

I don't know:

Please Login or Register  to view this content.

[billy60]

Within Copysheet there are these codes to show only certain columns:

Please Login or Register  to view this content.

[Logit]

I'd try doing away with the following :

Application.ScreenUpdating = False
Application.ScreenUpdating = True
ActiveSheet.Protect
ActiveSheet.Unprotect


See what happens on a COPY of the workbook. ...

[billy60]

I have a solution that should work. I inserted code to unhide all columns prior to copying in the code.

[billy60]

It would be better if you can open workbook to see what is happening. I need the protection to prevent editing of certain cells.