Skip to Content
0
Former Member
Dec 28, 2011 at 02:19 PM

AFTER_REFRESH

97 Views

Hi,

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..

Please advise.

Regards,

Shibu