i am trying to add a row to Execl at bottom of the sheet. I can select btnAddFacility prior to locking the Excel.
it adds a row at the bottom and i can edit. BUT, once I lock the Excel, the row i added while excel is unlocked is frozen, all the cells.
I can also add a row once the excel is locked, and that seems to work. should i be able to add new row prior to locking?
it adds a row at the bottom and i can edit. BUT, once I lock the Excel, the row i added while excel is unlocked is frozen, all the cells.
I can also add a row once the excel is locked, and that seems to work. should i be able to add new row prior to locking?