Thread: Word document with VBA and Form Fields reset when select File,Print
View Single Post
 
Old 04-26-2018, 09:18 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,105
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
There are no macros in your document. What you posted was a field calculation.

I never did like FillIn fields. The attached version uses a content control date picker to get the end date (which presumably will always be a Friday) and then populates the table based on that selection, using a macro.

If you want the end date to be any day of the week, remove the line
Code:
EndDate = EndDate - Weekday(EndDate) + 6
from the macro.
Attached Files
File Type: docm sample fields-1.docm (29.8 KB, 15 views)
__________________
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