Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2020, 11:50 PM
cadillac1206 cadillac1206 is offline Locking styles in Word using VBA to restrict new styles Windows 10 Locking styles in Word using VBA to restrict new styles Office 2019
Novice
Locking styles in Word using VBA to restrict new styles
 
Join Date: Apr 2020
Posts: 1
cadillac1206 is on a distinguished road
Default Locking styles in Word using VBA to restrict new styles

Hi,

I am new to using VBA, please forgive my ignorance. I am looking for help with adding VBA to my proposal template to restrict writers from adding random styles that destroys the original styles and formatting becomes a complex-time consuming task, which gets unaffordable at times.

Any help will be much appreciated.
Thanks,


Reena
Reply With Quote
  #2  
Old 04-21-2020, 01:08 AM
gmayor's Avatar
gmayor gmayor is offline Locking styles in Word using VBA to restrict new styles Windows 10 Locking styles in Word using VBA to restrict new styles Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

I suspect your proposal template would be fairly rigid in layout and would vary in relatively small ways that require user changes. You may be able to achieve and exceed the control that you require by using content controls for the variable parts of the text and protect the rest against meddling.

You may find Insert Content Control Add-In useful in this endeavour.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
restrictions, styles, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking styles in Word using VBA to restrict new styles Creating buttons for individual paragraph styles on a ribbon tab - not using Quick Styles T7Training Word 11 12-22-2019 12:16 PM
Does a new set of styles in a template overwrite or remove the existing set of styles in a document? dianahbr Word 6 03-27-2018 11:12 PM
Two much blank space between names of styles in the Styles Pane PereCasanellas Word 0 10-06-2017 03:47 AM
Question about spacing between multi-level bullet styles (and other styles) SDwriter Word 0 09-26-2017 09:39 AM
Restrict styles in a template chrizzbee Word 3 03-15-2013 02:23 AM

Other Forums: Access Forums

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