adding procedure after click button from the second time

[Omar M]

Hi Experts,
I have code ,running the code from the first time but if I click the button again then should call
sub macro1() before running my original code is sub test().
every time save and close the file.
the first time when run my original code will be when open the file .
I hope this clear guys.

[CK76]

Create global (public) variable to hold some value when it runs first time.
https://learn.microsoft.com/en-us/of...ring-variables

Then variable = value. Call the other subroutine.

Or alternately, hold some value in a cell. Then reset it upon save & close.

[Omar M]

I will check the link.

[Omar M]

I see the link show me declare variable!
what is relevant with my demand?

[CK76]

You declare some public variable. Let's say Boolean and set it to false initially.
Add process at end of 1st sub to set it to true.

Then you'd write another sub that calls both 1st and 2nd, but check if this variable is true. If so run the 2nd sub, if false, run the 1st sub.

This is used as check to see if 1st sub was executed.

[Omar M]

this will just run for sub test macro !

Please Login or Register  to view this content.

what's the correct?

[Sintek]

So...On first opening file...When pressing [button]
Call Test
On pressing [button] again Call Macro
And then when closing file and opening again what must run then....Test OR Macro

[Omar M]

And then when closing file and opening again what must run then....Test OR Macro

should be as the the file is open , as you mentioned

So...On first opening file...When pressing [button]
Call Test
On pressing [button] again Call Macro

[jindon]

Create a Static variable in test procedure, like

Please Login or Register  to view this content.

[Sintek]

every time save and close the file.
the first time when run my original code will be when open the file .

And then when closing file and opening again what must run then....Test OR Macro

[Omar M]

thanks jindon .
your code will run the first code after finishing will run the second code , this is not what I want , sorry.
On first opening file...When pressing [button]
will running first code ,On pressing [button] again will running first code (every time pressing [button] after pressing from the first time will just run the second code.
when save & close file , opening file again ...When pressing [button] the process start again (just run first code from first pressing [button],when repeat pressing [button] just running second code.
so first code will run from first time pressing [button] an run the second code from the second time when file is opening.

[Omar M]

And then when closing file and opening again what must run then....Test OR Macro

may you see post 11 ?
I hope hlep you.

[Sintek]

You are contradicting yourself...

On first opening file...When pressing [button]
will running second code

On pressing [button] again will running first code (every time pressing [button] after pressing from the first time will just run the second code.

Then you say...

when save & close file , opening file again ...When pressing [button] the process start again (just run first code from first pressing [button]

when repeat pressing [button] just running second code.

So what is it...???

[Omar M]

sorry about error , sintek .
indeed I find out and I was editing before you comment
editing post 11

[jindon]

Then like this?

Please Login or Register  to view this content.

?

[Sintek]

So first tiime always Macro1 thereafter always Macro2....
If file closes and opens then repeat above...

Please Login or Register  to view this content.

[Omar M]

both two codes works greatly .
thank you so much,guys.