Can any one explain to apply theme with the help of a button using macro for both sheet object and sheet..
Yes there is a macro code by which you can achieve this. They are.
Document - ActiveDocument.ApplyTheme "A:\Forest.qvt"
Sheet - ActiveDocument.ActiveSheet.Applytheme "A:\Forest.qvt"
Object - set obj = ActiveDocument.GetSheetObject("CH01")
Thanks, but it is applied before we click the button..is there any option for making the theme deactivate and then by clicking the button so the theme can be re applied??
How did you use the above statements.
Can you please upload the qvw file.
Ya sure I will attach my file..
Retrieving data ...