Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Could you provide me with the macro to hide a button when a chart object is minimized and show the button when the chart object is maximized.
Regards
Arun
In the API Guide , there is an example :
rem ** reverse minimize status for all sheet objects on sheet Main **
set s=ActiveDocument.Sheets("Main")
for i=0 to s.NoOfSheetObjects-1
if s.SheetObjects(i).IsMinimized then
s.SheetObjects(i).Restore
else
s.SheetObjects(i).Minimize
end if
next
Philippe
to hide an object , follow the example :
rem ** deactivate all sheet objects on sheet Main one by one **
set s=ActiveDocument.Sheets("Main")
for i=0 to s.NoOfSheetObjects-1
s.SheetObjects(i).Deactivate
next