I have written a macro for a specific purpose. I want that if a user interrupt the macro during run then macro should hide Column A to Column C on sheet 1 of the workbook before leaving. Is it possible? If yes, please suggest the code.
One possible idea.
You gotta add two lines to You Macro.
In the beginning, You have to set [A1]'s background color to 'any color'
and
just before the end, You have to set [A1]'s background color to 'xlnone'.
Of course, it's possible to select another 'trigger-point' too.
