View Single Post
 
Old 06-14-2021, 02:04 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,164
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 easiest way to use the macro is to add a MacroButton Field below the table. You then run the macro by double clicking that text. To do this:
1. Stop the Protection
2. Put your cursor immediately below the table and paste the following line of text
MacroButton DeciduousCCs Double Click to clear Annual fields
3. Select that text, change its colour so it stands out (eg Red) and press Ctrl+F9, then press F9 to hide the field code.
4. Reprotect the document
5. Make sure the macro is sitting in a module in the document and that macros are enabled.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote