Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any one explain to apply theme with the help of a button using macro for both sheet object and sheet..
Regards,
Guruprasth M
Hi,
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")
obj.ApplyTheme "Forest.qvt"
Regards,
Kaushik Solanki
Hi,
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??
Regards,
Guruprasath M
Hi,
How did you use the above statements.
Can you please upload the qvw file.
Regards,
Kaushik Solanki
Hi,
Ya sure I will attach my file..
Thanks,
Guruprasath M