Macros

[RGDeb]

I created a macro yesterday and it was working. How can I automate it to run
whenever the information changes? Also, I went back in this morning and
tried to run the macro and got the warning that macros are disabled for this
project. How do I enable them? I tried the security settings but that
didn't do anything.

Thanks!

 

[Gérard Ducouret]

<<How do I enable them?>>
Low down the Security settings (Tools / Macro / Security / Low) then close
the project file and re-open it.

<<automate it to run whenever the information changes>>
Look at the Help for the "Change" event in a VBA module

Hope this helps,

Gérard Ducouret