[mso] Excel/Word Macros - double enabling & size issues
- From: Cathy.Evans@xxxxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 6 Dec 2006 17:37:50 -0500
I have a Word document that contains an excel worksheet. The excel
worksheet has protected ranges and one macro-button to insert a row. When
I am in the Word document, if I right click to edit the worksheet, it will
ask me if I want to enable the macros, I say yes. Sometimes it asks me
twice, I think that was when I first pasted the worksheet.
The Word document itself has many macros, and it is the main document.
When it is first opened a user has to enable those macros. I don't want
them to have to again enable macros when they get to the page with the
excel worksheet on it. Is there a way I can automatically enable the excel
macros, too, from the word form, or whatever method is needed? The
worksheet is not linked. I have placed it there instead of using a Word
table to be able to do calculations. I have been studying and trying to
implement solutions from this link: http://support.microsoft.com/?id=317405
, but not successful yet. Our OS is XP, with Excel/Word 2002, but the bulk
of the users will be Office 2003. Should I give up trying to find a
solution and go back to manual table calculations in Word?
Because the 2nd issue is that if they insert more rows than are originally
provided (this will happen in a small percentage of forms), I haven't found
out how to allow the excel worksheet in Word to automatically 'grow' with
the rows added. In Microsoft Access I can tell a form field to grow or
shrink with data entry text, but don't know if it can be done here.
Thank you for any help,
Cathy
-----------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain proprietary,
business-confidential and/or privileged material.
If you are not the intended recipient of this message you
are hereby notified that any use, review, retransmission,
dissemination, distribution, reproduction or any action taken
in reliance upon this message is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer. Any views expressed in this message
are those of the individual sender and may not necessarily reflect
the views of the company.
-------------------------------------------------------------------------------------------------------
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
- » [mso] Excel/Word Macros - double enabling & size issues
