Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2018, 02:24 PM
macropod's Avatar
macropod macropod is offline Return Freeze panes location Windows 7 64bit Return Freeze panes location Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


I prefer the With … End With structure. More importantly, though, your omission of 'ActiveWindow.SplitRow = 3' means you're no longer controlling the possibility that someone might have manually changed the row split.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 09-18-2018, 02:49 PM
trevorc trevorc is offline Return Freeze panes location Windows 7 32bit Return Freeze panes location Office 2013
Competent Performer
Return Freeze panes location
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

I'm the only user so not a problem, and the macro button is only on the ActiveWindow, so don't need the With...End With.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Default location for the Office Document Cache Server drafts location. dianahbr Office 0 03-02-2018 12:37 PM
Return Freeze panes location Return to previous location in Word 2016 stevelsd Word 2 09-30-2017 06:18 AM
How to Customize Outlook Panes Steve_B Outlook 0 07-08-2014 09:05 AM
Freeze more than just the top row, or first column Gary Drumm Excel 4 07-23-2013 11:34 AM
Outlook 2007 win7x32 Archive location/backup location question michael.monaco Outlook 0 11-19-2012 02:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 PM.


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