Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-05-2013, 08:19 PM
lms lms is offline Macro Best Fit Windows 7 64bit Macro Best Fit Office 2007
Novice
Macro Best Fit
 
Join Date: Jun 2013
Posts: 9
lms is on a distinguished road
Default Macro Best Fit

I created a list of Defined Views that each one shows different fields in the columns of the contact folder. I then found this macro that is perfect that I can use to adjust the view of the contacts and decide which Defined View to show...but the Defined View field areas are not saving the "Best Fit" area for each field.....Is there something to add to the macro or another macro to automatically best fit all columns automatically using the macro?

Sub GetAssignedView_Name_of__Fields()
Dim objViews As Views


Dim objView As View
' Applies view to select folder
Set objViews = Application.ActiveExplorer.CurrentFolder.Views
'Get the view
Set objView = objViews.item("View Defined View Name")
'apply the view
objView.Apply
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
custom icon, undo/redo for macro, permanent macro Rapier Excel 0 08-05-2013 06:30 AM
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:16 AM.


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