Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-12-2014, 10:16 AM
rjrichar40 rjrichar40 is offline Using VBA to change styles causing TabStop problem Windows 7 32bit Using VBA to change styles causing TabStop problem Office 2010 32bit
Novice
Using VBA to change styles causing TabStop problem
 
Join Date: Aug 2014
Posts: 11
rjrichar40 is on a distinguished road
Default Using VBA to change styles causing TabStop problem

I've got a series of macros so users can choose paragraphs and style them according to company standards. This way if they inadvertently change fonts, they can select a page and put everything to "approved" style standards.



However, one adverse effect is that afterwards, if they choose to put in a custom tab stop on a single paragraph... it adds the same tab stop to all paragraphs. Before styling, they can tabstop individual paragraphs. After styling, the tabstop goes onto each paragraph regardless.

I am not sure why, or how to fix this. Would there be a style setting that links them all together in this way? Something I can avoid? Is there VBA code for an onclick event for the ruler, so if they try to add a tabstop maybe I can intervene so it only effects the current paragraph?

Rather confusing question... but I thought I'd ask.
Reply With Quote
  #2  
Old 08-12-2014, 10:22 AM
gmaxey gmaxey is offline Using VBA to change styles causing TabStop problem Windows 7 32bit Using VBA to change styles causing TabStop problem Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,427
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Sounds like the style property AutomaticallyUpdate is set to true. Set it to false.

ActiveDocument.Styles("Your style name").AutomaticallyUpdate = False
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #3  
Old 08-12-2014, 10:35 AM
rjrichar40 rjrichar40 is offline Using VBA to change styles causing TabStop problem Windows 7 32bit Using VBA to change styles causing TabStop problem Office 2010 32bit
Novice
Using VBA to change styles causing TabStop problem
 
Join Date: Aug 2014
Posts: 11
rjrichar40 is on a distinguished road
Default That may have done it...! Going to test it out

Seems to have an impact. I'll experiment with it. Thanks!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using VBA to change styles causing TabStop problem Importing Styles causing odd formatting problems. Red Pill Word 3 06-12-2012 06:19 AM
QAT Table Styles problem Ulodesk Word Tables 2 08-15-2011 11:54 AM
Using VBA to change styles causing TabStop problem Why do imported styles not change to default font? OldGrantonian Word 4 05-18-2011 06:35 AM
problem with font when using styles ehamike Word 0 06-24-2010 09:56 AM
Why can't I change certain styles back to normal? SuperHans Word 1 10-16-2009 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 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