PDA

View Full Version : VBA Word Code - newbie



Finneghan
03-11-2017, 04:10 AM
Hi there,
trying to write my very first vba macros to:
1st macro - unprotect a form, shade a single cell in form dark gray, and reprotect the cell
2nd macro - as above, but shades the cell white
ive tried to record the macro, but am unable to click on protect in developer tab.
please help.

Logit
03-11-2017, 08:45 AM
Protecting / Unprotecting a cell:

http://excel-macro.tutorialhorizon.com/excel-vba-range-lockunlock-specific-cells/


Change cell color :

http://www.excel-easy.com/vba/examples/background-colors.html

Finneghan
03-11-2017, 10:11 AM
Thank you for that information, how do I do this in word?

Logit
03-11-2017, 10:25 AM
Protecting / Unprotecting a cell:

http://www.techrepublic.com/blog/microsoft-office/how-to-protect-cells-in-a-word-table-using-a-text-form-field/


Change cell color :

https://wordribbon.tips.net/T010932_Copying_Fill_Color_in_a_Table.html