Changing Forms

[Gonçalo Ricardo]

I have this problem:

I’m working with a VB from in a excel apllication,
That macro is personalized; the problem appears when someone run
another application that uses the same macro that’s personalized to.
For example one macro have a picture in if some one opens anothe
excel application and runs the same macro it doesn’t change th
picture.
How can I resolve this problem?

Thanks

 

[Bob Phillips]

You would need to save the changed state somewhere outside of the Excel app,
such as a database or a file, and when anyone starts up, they read this
state. You might also need to keep checking back in your macro to see if it
has been updated. Not trivial.

--

HTH

RP
(remove nothere from the email address if mailing direct)