We have written Macros (using Visual Basic) in a few input schedules in order to build adequate controls. One requirement was that planning should not be allowed in a few rows & columns. The macro automatically runs when we open the input schedule.
When we refresh the data, the macro stops working. We want the macro to work at all times...We used a few custom VBA Functions (i.e. AFTER_REFRESH) and wrote a VB code to run the above macro after every refresh. However the same does not work..