View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default My unsolved mystery!

Hi

I think it's a security setting issue.

Open the Developer tab in Word ribbon and change security settings.
Then try to open the document.

Hopes this helps.

---
Per

On 7 Maj, 00:28, Dan the Man
wrote:
I have a Userform that was made up for me by a friend which I use to post
comments in. The form interacts with Excel, and when Excel is open, it calls
up a "Userform" in Word. I'm Using Office XP: Home Edition (Word and Excel
2002) btw.

I was attempting to transfer my spreadsheet with Userform to a friends
computer (she has Vista and Office 2007). When I looked at the VBA coding on
the particular word file, I noticed that the "Forms" file was not there
(under Project), and the Userform we created was nowhere to be found.

I understand the difference between "Project" (which is specific to a
document) and "Normal" (which places the code or in this case Userform
globally throught), and realize that I have to move the Userform we created
from "Project" to "Normal", however the Userform didn't exist when the Word
file was moved from my XP/Office 2003 computer to the Vista/Office 2007 based
computer. I was able to create a "blank" "forms" folder (which the Userform
currently exists in on my computer), but my "created" Userform template does
not seem to want to transfer with the Word file.

I also had attached code (for some of the Userforms functionality) in a
Module that I created, and this too would not transfer between the computer.s

Funny, I moved the same documents to a computer with XP and Office 2003, and
everything (including the Userform template, and module coding) was there,
and all worked well. I had no difficulties. Something about Vista and Office
2007 seem to be working against me.

Any suggestions?

Dan

PS: I posted this same question in the Word Programming Section, however, it
does not look as if there are many responses to a lot of the questions, and
I've always found this discussion group to be quicker to
answer.................