Hey guys. I'm writing an app using macros assigned to a custom toolbar. As it is now, all of the macros rely on being run from a specific column in the middle of the sheet. Because of the specific ActiveCell.Offset values, the user needs to make sure the macro is run while within the column they are designed for.

I would like to make this fail proof. I would like to encase the macros in an If statement that checks to see if the active cell is in the specified column and if not, moves the active cell to the column before running the macro.

Any suggestions?