Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-13-2018, 09:08 PM
Guessed's Avatar
Guessed Guessed is offline Page.SetTheme Method example VBA? Windows 10 Page.SetTheme Method example VBA? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,995
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

No you read it correctly but as I said, Visio's VBA doesn't make a great deal of sense. When I recorded it saved the theme as
.SetTheme 35, 35, 35, 35, 35
which is plainly stupid but most of those variables are optional so I removed them to make it simpler

In VBA, the brackets are optional unless you are trying to set a variable at the same time eg
Set aDoc = Documents.Add(sPath)
vs
Documents.Add sPath
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Page.SetTheme Method example VBA? Sorting method Steve Bartko Excel 6 10-26-2016 11:38 AM
Page.SetTheme Method example VBA? Why no 'SaveCopyAs' method? Cosmo Word VBA 4 10-18-2013 05:57 AM
Page.SetTheme Method example VBA? Creating a sorting method. Balliol Word 2 07-25-2013 06:18 AM
Page.SetTheme Method example VBA? Shared Contacts & Calendars. Best method crobertson Outlook 1 05-08-2009 05:47 AM
Retrict Method Condition markp Outlook 0 12-22-2005 05:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft