krishnak
08-28-2010, 10:16 AM
Hi All,
In a worksheet I have input data cells which are filled in by the user. In the same worksheet, I have columns containing cells with the output data calculated from the input data. The calculation and populating the output data is done by vba code by pressing a button on the worksheet.
I want to lock the cells in the output columns so that no one can overwrite them. However when I lock these cells, even the macro is not allowed to populate these cells when I press the button.
Is there any way out?
In a worksheet I have input data cells which are filled in by the user. In the same worksheet, I have columns containing cells with the output data calculated from the input data. The calculation and populating the output data is done by vba code by pressing a button on the worksheet.
I want to lock the cells in the output columns so that no one can overwrite them. However when I lock these cells, even the macro is not allowed to populate these cells when I press the button.
Is there any way out?