Multiple actions within a Button

[#1]

Hi,

I am doing the following actions within the button:

1. Setting a variable to 1

2. Calling a Macro to export a chart in Excel

3. Setting the variable back to 0

Now, the challenge is they don't happen sequentially as I desire.  Looks like I can only have one Macro inside a button because I tried one more macro to call a hidden button to do the third action and it did not work.  Please suggest how I can control the order of execution of actions within the button.

Thanks,

Sudha.

[Anonymous]

why don't you enhance the macro and set the variable back to 0?

[#3]

Hi,

Yes I thought about it.  I am new to Macros.  Please help me how I can integrate,

set vShowColumn=0

after the completion of this macrosub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH02")

obj.ExportBiff "C:\Temp\GL.xls"

end sub

Thanks,

Sudha.

[Anonymous · Accepted solution]

try this

set v=ActiveDocument.Variables("yourvariable")

v.SetContent "0",true

[#5]

Thank you so much!! It worked