Hi everyone,
I have a problem with a word document that I have created a couple of years ago. This document is used for the employees assessments. The first page (page 1) is the homepage containing all my buttons and all other pages are hidden by a VBA code. So the buttons on the homepage are used to redirect the user to a specific section and unhide this section. This document will be completed at first by the employee and then, his supervisor will complete some sections.

My problem is that recently, an employee has completed the form in word 2007 and then he transferred the file to his supervisor but the supervisor is now unable to use the buttons on the homepage. So the supervisor is unable to see the evaluation of the employee. The version of the supervisor is word 2010. If I try to open the file with my word 2013, everything works find. If one of my colleague that is using word 2007 open the file on his computer, everything is working well too... It seams to be a problem with the 2010 version. I also tried to save the file with my 2013 version and resend the file to the supervisor and it still doesn't work.

Since Microsoft recently had a problem with an update (Form Controls stop working after December 2014), I was wondering if this problem could be related because last year we used this form without any problems. To solve the problem of the update of December, we deleted the .exd files and it works find but if we use a file created by an other version of word (2007 or 2013) and we try to open this document in word 2010 all the macros are not running...

What do you think... I'm not a very good with this kind of issues... Please help me if you have any ideas or if you have any suggestions of tests...

thanks in advance,



bouclesdor

I did another tests with an other word file containing buttons with VBA codes. If i save the document with my 2013 version (and probably with the 2007 version) and when another user try to open the file with the 2010 version, the buttons stop working.... It's not a problem with my file but it's seams to be a problem of compatibility of versions....

Why??
Any ideas who to solved the problem...?

Thanks again,

Bouclesdor

no answer....!!!

OK I will try to contact Microsoft office...

Thanks anyway!

This doesn't sound like a version problem. The problem is most likely due to the availability of the macros on the problem machine. Your description sounds like macros are involved to show/hide the content.

The questions to ask are:
1. Do the macros reside in the document or is there an attached template? If there is an attached template, does the machine with the problem have the template installed?
2. Does the machine with the problem allow macros to run with their security settings?
3. Can the user on the problem machine simply go into their options and show all 'hidden text' to reveal the hidden content?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

There was a bug in the December update that caused this type of problem. The simplest solution is to locate the Windows User Temp file (Type %temp% in the Windows Explorer address bar) then with ALL office programs closed. Delete all the files in the folder that are not in use. Windows will replace any it needs next time the applications are run.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Guessed and Gmayor: Thanks to both of you for your replies! It's really appreciated!!

Guessed :here are the answers to yours questions:
Question #1: Yes the macros reside in the document so it's not a problem of uninstalled template.
Question #2: Yes the macros security on the machine with the problem enable all macros to run on the computer... So it should be running without any problems...
Question # 3: Yes the user can go to the options "Show/hide" hidden text but the macros need to work because I also have a print button to print specific sections and I also have a button for calculation field. Temporarily, we used this option but I need to fix the problem...

Gmayor: I have asked the user with the problem to delete "%Temp%" files and I'm waiting his feedback... hopefully it will work... I'm crossing my fingers... I will let you know as soon as he comes backs to me...

Thanks again to both of you for your kind help,

Bouclesdor

Gmayor: The user has deleted the %temp% files on his computer and the problem still there...

Did he have all of Office closed? Reboot first to be sure. Then delete the temp files.
If that doesn't fix it, then it is unlikley to be the problem relating to that particular update.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Everything was closed on his computer. All the %Temp% files were deleted but we still have the same problem with the document...

Thanks Gmayor for your kind help...

I'm posting back some results of my 1 thousand tests just in case someone could help me...

At first, I thought that it was a problem related to versions of office but I have asked some colleagues to open and run the macros and send back the file to the person with word 2010 and for some reasons, one computer with word 2007 is working and another with 2007 doesn't work...

After that, I found out that if I open and save the file with my word 2013 the person with word 2010 won't be able to use the macros (the macros seams to be disable, we can click on the button but nothing happens, no VBA is running. But if a person with word 2007 (the version that work) open and save the same file I have opened earlier (with my 2013 version), the person with word 2010 will be able to open the file and all the macros will work correctly... It seems to reactivate the macros that were disable in the 2013 or the 2007...

any ideas of the source of this matter...

Thanks in advance for your kind help...

I forget to mentioned that I have compared all the settings of my word 2013 with the word 2010 (macros security, trust center, options, ...) and everything seems to be the same...

I haven't seen this problem before so I don't have many ideas on what might be going on.

If it is a compatibility issue then do any of these machines show the document is in 'Compatibility Mode'? Can you convert it to the correct format to resolve the macro issue?

On a machine that can't run any of the macros, it is possible to open the Visual Basic Editor and compile the project? Does that allow the macros to run?

If the macros fail to run, can your user save the document to RTF and then reopen it to get the macros going again?

I note your latest testing results seem to point to a different scenario to that you presented in your first post so the problem may have more than one way to arrive at the issue.

Are you able to post a sample document/template that we could test ourselves? I don't have a machine running Word 2007 anymore but can test on 2010 and 2013.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi Guessed,

First of all, thanks for taking the time to help me. It's really appreciated since I'm not an expert in computers problems...

The document doesn't seem to be in "Compatibility mode" (I don't see this comment beside the file name...) I don't know if there is another way to verify... Also, just to make sure that I was not in compatibility mode, I have save again the file on the computer and it still doesn't work.

I did compile the projet on the computer who have the problem and I have the run time error 32809 Application defined or object defined error. I think this is the same error message that everybody had after microsoft update of mid December... Since the beginning I'm thinking that my problem is related to this update because we used this document since 2 years without any problems but recently, every thing stop working on 2010 version even after trying to delete the EXD files, %temps% files, deleting the update KB2553154 (for 2010 version),... I still have the problem. Maybe I'm wrong to think that, but I don't see anything else that can have created this bug...

I also tried to save the document in RTF on the computer that doesn't run the macro and after saving it I save it again in enable document and the macros still doesn't work....

I have attached a test file that I have created (on my word 2013) with a VBA code (very basic code) that is supposed to get me to 3 different sections in the document but when I try to run the macro on a word 2010, the macros doesn't work. If I send the same file to 2 different computers with word 2007, both will be able to run the macros but for one user (the one that is working or should I say, how is repairing the macros for some unknown reasons...) and I only save the document (without any changes) and send it back to the person that use word 2010, it won't work but if I'm making some modifications like if I'm typing some text "blablabla" and than save the document and send it back to my colleague that use the word 2010, the macro will start to run properly... I'm unable to figure out why one of the 2007 version can repair the files and make it accessible for the word 2010...

Maybe you could try to open my file with your 2010 version and see if you can run the macros on your computer...

This afternoon, I will ask my IT Department to uninstall all the updates on a computer with word 2010 that has the problem and then install a old update (before december) to see if i'm right to think that it's a problem with December updates...

Thanks again for your kind help,

Bouclesdor

Attached Files

sans hide text cycle performance .docm (23.2 KB, 11 views)

The problem exists on my Word 2010 and Word 2013 machines. It seems to be the ThisDocument module where the problem lies. I can move the macros into a new module and they run happily there (directly) but fail to run in ThisDocument which is where they need to be for the ActiveX objects to kick them off.

A workaround would be to re-create those buttons on the ribbon - which in my opinion is the best place for them anyway.

I note that the issue appears a few times and there are several patches that get a mention
http://blogs.technet.com/b/the_micro...-updates-.aspx
http://stackoverflow.com/questions/2...trols-disabled
http://dailydoseofexcel.com/archives...ivex-controls/
I haven't had any luck clearing the specified file types either.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Just to throw a spanner in the works, I have tested the document here (Word 2010 with all updates) and it works without problem. The only time I had problems with Active X objects was after the December update and that was resolved by clearing the Temp folder and in particular the EXD files.

Have you tried repairing Office?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com