BlueDNA
04-27-2006, 06:31 PM
Hi guys,
Im working on this macro that runs through a loop and checks the integrity of the cells in those records.
The problem that im having is, when the loop runs, i would like to stop the user from being able to click on the cells in the sheet that are being validated (since this is causing some problems and the macro to crash).
I do not want to protect the worksheet, since i would need to unprotect and protect the cells again everytime a cell value is changed/modified.
Locking the sheet would be the same as well?
At the moment, i have set the visibility of the workbook to false while this loops runs and back to true again when validation has completed.
Any advice would be greatly appreciated, as usual!
Cheers guys.
:hi:
Im working on this macro that runs through a loop and checks the integrity of the cells in those records.
The problem that im having is, when the loop runs, i would like to stop the user from being able to click on the cells in the sheet that are being validated (since this is causing some problems and the macro to crash).
I do not want to protect the worksheet, since i would need to unprotect and protect the cells again everytime a cell value is changed/modified.
Locking the sheet would be the same as well?
At the moment, i have set the visibility of the workbook to false while this loops runs and back to true again when validation has completed.
Any advice would be greatly appreciated, as usual!
Cheers guys.
:hi: