Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveWorkbook.SaveAs | Excel Programming | |||
ActiveWorkbook.ConflictResolution | Excel Programming | |||
Using ADO to read from ActiveWorkbook | Excel Programming | |||
ActiveWorkBook | Excel Discussion (Misc queries) | |||
ThisWorkbook vs. ActiveWorkbook? | Excel Programming |