Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 09-29-2020, 09:25 PM
Guessed's Avatar
Guessed Guessed is offline Changing background colour in table based on value. Windows 10 Changing background colour in table based on value. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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

The code includes a line at the end that protects the document. If you disable that line you remove the protection that is reinstated EVERY time the code runs. This would allow you to edit the document normally and remove the table.



The line you want to disable is
ActiveDocument.Protect wdAllowOnlyFormFields, True, StrPwd

You disable it by adding a single quote in front of it
'ActiveDocument.Protect wdAllowOnlyFormFields, True, StrPwd

Then return to your document and move your cursor from one CC to another to ensure the code has run. You will then be able to edit the doc. If you want the document protected for your users, just go back in to the code and delete the single quote again. Note that you don't have to use a protected document to see the code do the colouring.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #17  
Old 09-29-2020, 09:27 PM
amandalee amandalee is offline Changing background colour in table based on value. Windows 10 Changing background colour in table based on value. Office 2013
Novice
Changing background colour in table based on value.
 
Join Date: Sep 2020
Posts: 12
amandalee is on a distinguished road
Default

And i also need to add more text between the tables...... but cant seen to modify he document. Is there a way that i can perhaps protect the tables but make changes to the rest of the document?
Reply With Quote
  #18  
Old 09-29-2020, 09:40 PM
Guessed's Avatar
Guessed Guessed is offline Changing background colour in table based on value. Windows 10 Changing background colour in table based on value. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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

Firstly, I would question whether you REALLY need to protect the document. If you trust your users then the protection is not necessary.

If you don't trust your users, but do want them to add/change other content then you can add Content Controls (eg Rich Text or Plain Text) to other areas where you want content to be editable by your users.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #19  
Old 09-29-2020, 09:45 PM
amandalee amandalee is offline Changing background colour in table based on value. Windows 10 Changing background colour in table based on value. Office 2013
Novice
Changing background colour in table based on value.
 
Join Date: Sep 2020
Posts: 12
amandalee is on a distinguished road
Default

Andrew, all problems solved except for the original box at the top... i just cant delete it because it is saying it is protected - even after the change
Reply With Quote
  #20  
Old 09-29-2020, 09:52 PM
amandalee amandalee is offline Changing background colour in table based on value. Windows 10 Changing background colour in table based on value. Office 2013
Novice
Changing background colour in table based on value.
 
Join Date: Sep 2020
Posts: 12
amandalee is on a distinguished road
Default

I have managed to fix the remaining issue myself, Thank you very much for all of your help. Amanda

Last edited by amandalee; 09-29-2020 at 11:05 PM. Reason: Corrected issue
Reply With Quote
  #21  
Old 09-29-2020, 09:57 PM
amandalee amandalee is offline Changing background colour in table based on value. Windows 10 Changing background colour in table based on value. Office 2013
Novice
Changing background colour in table based on value.
 
Join Date: Sep 2020
Posts: 12
amandalee is on a distinguished road
Default

It probably does not need to be locked at all i don't think. They submit this report each month hopefully they don't modify anything to do with this,
Reply With Quote
  #22  
Old 09-30-2020, 03:13 PM
Guessed's Avatar
Guessed Guessed is offline Changing background colour in table based on value. Windows 10 Changing background colour in table based on value. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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

I would leave it unlocked for a while and see how it goes. If people are deleting or rewording questions then you can have an adult conversation with them to understand why they think that is necessary and you can either:
1. Change the questions based on that feedback
2. Lock it down so they are forced to answer the questions you want answered.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Background Word Colour not showing on PDF phorsley Word 1 04-24-2020 09:18 AM
Changing background colour in table based on value. Text Background Colour in a Table Colin Vicary Word 4 08-08-2019 06:02 AM
Word background colour ignores Windows setting wiganken Word 1 07-19-2018 09:25 AM
Changing background colour in table based on value. Changing background colour based on dropdown choice PLeo Word VBA 2 08-03-2017 07:40 AM
Trying to clear the background colour from a theme ezekiel181 Word 1 11-14-2010 07:29 AM

Other Forums: Access Forums

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