Hi,
Kindly view the attached file it has macro to copy INVOICE details to INVOICE MAIN sheet and INVOICE INVENTORY SHEET, when i run a macro it shows the sheet (inventory sheet) need to be copied and comes back to active sheet ( invoice sheet) but
what i notice is it stays in active sheet (invoice sheet) without showing any sheets ( inventory & main ) if unprotected (i just remove the code and unprotect the sheets and checked )
So ift the sheets are protected is that the way macro run ?( showing copying sheets and comes back to active sheet) or i have done anything incorrect?
Pls advise
Password "1234"