Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to verify if a specific multibox is active within a macro. I can see how to loop through in the api guide, but cant figure out how to check if a specific multi is active. Tried using
if
ActiveDocument.ActiveSheet.GetSheetObject("MB01").GetProperties.IsActivethen
but that doesnt work. what is the correct syntax to reference a specific multibox?
try this one:
sub Test
set myBox = ActiveDocument.GetSheetObject("MB01")
if myBox.IsActive then
msgbox("Active!")
else
msgbox("Not Active!")
end if
end sub
try this one:
sub Test
set myBox = ActiveDocument.GetSheetObject("MB01")
if myBox.IsActive then
msgbox("Active!")
else
msgbox("Not Active!")
end if
end sub
call this macro when the sheet activates
Thank you, works great