Macro to Set Checkbox Based on Value of SharePoint Document Property


i'm total beginner writing word macro, or in vba matter. figure want can't hard. have request forms (word documents - .dotm files) stored in sharepoint 2010 site. i've configured sharepoint content type 3 columns - each choice field yes or no values. perhaps use true/false when know more macros. client yes/no fields shown in document checkboxes - looks better! think need have macro runs whenever document opened check value of sharepoint columns - activedocument.contenttypeproperties("column name").value - and set activedocument.formfields("checkbox name").value true or false accordingly, using if else statement. i'll need reverse whenever document saved (check formfields , set contenttypeproperties).

so start? developer tab, macros, create...but what?

thanks,

tom


sharepoint systems officer, capital regional district, bc, canada

hi,

i think want how create word macro.

so following link you:

http://msdn.microsoft.com/en-us/library/office/ff604039(v=office.14).aspx


jaynet zhang
technet community support



Microsoft Office  >  Word IT Pro Discussions



Comments

Popular posts from this blog

Error: 0x80073701 when trying to add Print Services Role in Windows 2012 Standard

Disconnecting from a Windows Server 2012 R2 file sharing session on a Windows 7,8,10 machine

Windows 2016 RDS event 1306 Connection Broker Client failed to redirect the user... Error: NULL