Macro controled by Cell content

[Jamie Wagler]

Hello,

I am wondering if it is possible if I can control a macro with the content within a cell.

I have a shop calendar which (using a macro) I want to roll ahead 1 period. I have an IF( statement in a cell which will read as "Locked" when I roll the calendar forward more than one period from the presant day. Is there a way in which I can control the macro to not roll forward a second time either through this cell reference or by any other means?

 

[Momentman]

With worksheet evemts, you can trigger a macro based on changes to a target cell. That much I know

 

[Jamie Wagler]

Perhaps I misunderstood you, I'm not sure that helps me out.

I want to limit the number of times that I can roll the calendar forward or back. IE I do not want to be able to run the macro (which is initiated through a button) more than once.