Hope this makes sense, I have a worksheet that contains both a VBA and a Macro. The VBA, by entering a value in cell A3 and press enter the VBA works as it should and locks the sheet after running,
For the Macro, I enter a value in to Cell A2, once i press enter or tab off that cell (prior to running the macro) the sheet unlocks. I have tried utilizing a different cell for the VBA with no difference.
If I remove the VBA the Macro work as it should, and not unlocking till running the Macro and locking once completed.
Thanks
For the Macro, I enter a value in to Cell A2, once i press enter or tab off that cell (prior to running the macro) the sheet unlocks. I have tried utilizing a different cell for the VBA with no difference.
If I remove the VBA the Macro work as it should, and not unlocking till running the Macro and locking once completed.
Thanks