CDR Tickets

Issue Number 4111
Summary Update Board Manager's Word Macros after Office 365 Install
Created 2016-05-25 12:56:39
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2016-05-26 18:55:46
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.184973
Description

We're updating the MS-Word macros after the Office 365 install. This update will require all board manager's macros to be updated with the changed version

Comment entered 2016-05-25 16:02:22 by Englisch, Volker (NIH/NCI) [C]

PCIB has already gotten their shiny new version of O365 and it appears that we need to redo the setting in Word allowing the users to run Macros.

  • In File -> Options -> TrustCenter --> Trust Center Settings...

  • Under Macro Settings check Enable all macros (not recommended)

  • In Trusted Locations replace the Word Startup directory with
    C:\CDR\WordStartup

  • In File -> Options -> Advanced -> General -> File Locations... set the Word Startup directory to
    C:\CDR\WordStartup

Comment entered 2016-05-26 18:55:26 by Englisch, Volker (NIH/NCI) [C]

Once the above settings have been restored the CDR Macros file will need to be copied from

L:\OCPL\_Cross\CDR\WordStartup\CDR_Macros.dotm

to

C:\CDR\WordStartup

With these changes the Word macros for summaries should work again without throwing an error.

Comment entered 2016-05-27 10:08:38 by Juthe, Robin (NIH/NCI) [E]

Volker, I tried following the instructions above but I got stuck on the last one:
In Advanced -> General -> File Locations... set the Word Startup directory to
C:\CDR\WordStartup

Where is "Advanced"?

Comment entered 2016-05-31 14:07:08 by Englisch, Volker (NIH/NCI) [C]

After the new macros definition file has been copied to the board managers computer, please have everyone double-check to ensure their individual macro is still working. As we have seen, Robin, I had to adjust yours and Sharon's macros to handle the formatting of the headings properly.

Comment entered 2016-05-31 14:14:22 by Juthe, Robin (NIH/NCI) [E]

This still isn't working correctly for me, but I'm sure I'm doing something wrong. I copied the latest CDR_Macros file from the OCPL\Cross drive to my C:\ drive but I'm still experiencing problems with links and font types & sizes.

Comment entered 2016-06-01 13:38:41 by Englisch, Volker (NIH/NCI) [C]

The macros for Sharon, Robin J, and Diana have been installed and are working correctly.
Currently working on Victoria's and Val's macros.

I don't remember: Did Robin B. test her macro, too?

Comment entered 2016-06-01 13:42:12 by Juthe, Robin (NIH/NCI) [E]

No she hasn't. She's out of the office, so we'll have to catch her next week.

Comment entered 2016-06-07 18:51:07 by Englisch, Volker (NIH/NCI) [C]

The following users need to have the maro file updated:

  • Robin Juthe ✔

  • Diana Blais ✔

  • Victoria Shields ✔

  • Valerie Dyer ✔

  • Robin Baldwin ✔

  • Bonnie Ferguson ✔

  • Sharon Quint-Kasner ✔

  • Margaret Beckwith ?

Comment entered 2016-06-08 11:54:41 by Englisch, Volker (NIH/NCI) [C]

I copied the new macros to Bonnie's computer but she doesn't have O365 installed yet. She will put in a ticket to get O365 and I will adjust her macro settings once that's done.

Comment entered 2016-06-15 14:06:40 by Englisch, Volker (NIH/NCI) [C]

Hi Robin, Val is the only one who still needs to have her macros updated. Is she on vacation?

Comment entered 2016-06-23 11:05:50 by Juthe, Robin (NIH/NCI) [E]

Val is going to give her macro a try today.

Comment entered 2016-06-23 11:12:24 by Englisch, Volker (NIH/NCI) [C]

If Val has the new O365 we already know that it won't work. I will need to setup the macro and adjust the macro definitions in the O365-Word settings.

Comment entered 2016-06-23 11:16:10 by Juthe, Robin (NIH/NCI) [E]

I installed the new macro on her computer a few weeks ago - it worked except she reported problems with the page numbers, headings, etc. She is going to follow my instructions to recopy the file and try it again to make sure it's working as she expects it to now.

Comment entered 2016-06-23 11:31:47 by Englisch, Volker (NIH/NCI) [C]

She will also have to go to the Word options (File -> Options -> Trust Center --> Trust Center Settings) and allow macros to run.

Is Val in the office today? It only takes a few minutes to check the options and I'll be happy to check our her setup.

Comment entered 2016-06-23 11:34:26 by Juthe, Robin (NIH/NCI) [E]

Yes she is~ sounds good! Thanks.

Comment entered 2016-06-23 13:38:48 by Englisch, Volker (NIH/NCI) [C]

Everybody has the newest version of the macro file and the summary macros are working properly.

I believe this ticket can be closed now.

Comment entered 2016-06-23 13:41:42 by Juthe, Robin (NIH/NCI) [E]

Agreed, thank you!

FYI - There are still some issues with underlining in the TOC, but I will open a separate ticket if we decide to fix that.

Elapsed: 0:00:00.001505