LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JNW JNW is offline
external usenet poster
 
Posts: 480
Default determine current theme in xl2007

Is there a way to determine the current file being used as the theme in xl2007.

I know you can load different themes by using (watch line break)
ActiveWorkbook.Theme.ThemeColorScheme.Load ( _
"C:\Program Files\Microsoft Office\Document Themes 12\Theme
Colors\Equity.xml")

But I can't figure out how to get it to tell me which file it is currently
using.

Thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function to determine current cursor position? Dan Excel Worksheet Functions 1 March 12th 09 02:56 PM
How to determine the current position of an open .xls file? Andrew Excel Programming 3 March 20th 07 10:09 PM
How to determine whether Cell is in current view? Joe HM Excel Programming 2 April 6th 06 10:12 PM
Find cell and determine value in current row Kathy - Lovullo Excel Programming 1 December 28th 04 02:13 PM
Determine current default fill color Steve Conary Excel Programming 0 December 2nd 04 05:08 PM


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"