ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Activeworkbook.ApplyTheme() (https://www.excelbanter.com/excel-programming/434082-activeworkbook-applytheme.html)

rick

Activeworkbook.ApplyTheme()
 
Is there a way to override any User-chosen theme and apply a theme to a
workbook?

I have developed the workbook using the Office built-in theme. I am able to
apply any theme (other than Office) with:
<unprotect sheets
ActiveWorkbook.ApplyTheme ( _
"C:\Program Files\Microsoft Office\Document Themes 12\Aspect.thmx")
for example.

But, it looks like the Office theme is not available as it is not in the
Document Themes 12 library.

When I applied the Office theme, the command captured by the macro recorder
was ActiveWorkbook.ApplyTheme () however that gives a syntax error during
compile.

Any help would be appreciated.
Thanks.

Rick



All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com