VB in MS Word, Skip Prompts..?

I have pasted in some charts and spreadsheets from Excel 97 into Word 97 and the only way I could get it to paste in without locking up was to paste special with link.

Now every time I launch the word file, its prompting me to allow macros to run or not to. But its doing it many, many times. I'm guessing because the word doc has about 6 charts and 6 spreadsheets pasted into it.

Suggestions on how to bypass all this prompting. I want to allow macros everytime I guess. What would be the steps to enter in a bypass within the VB for this document? Keeping in mind that I know relatively nothing about VB.

Thanks for any help,
CE
CeffelAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Farzad AkbarnejadDeveloperCommented:
Hi Ceffel,
Go to Tools > Macro > Security... menu in Word and set it to Low security.

-FA
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CeffelAuthor Commented:
Ok, that isn't working for some reason. It continues to prompt me even after I removed that selection.

Thanks,
CE
0
mbizupCommented:
You may also need to do that in excel.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

CeffelAuthor Commented:
Ok, that worked. Thank you very much for your help!!!
0
mbizupCommented:
Ceffel,

I'm glad I could help.  However, I think a points split here would have been more appropriate, as FarzadA's post was instrumental as well.  You can post a question in community suppors with a clickable link to this question, and they can help you out...
0
CeffelAuthor Commented:
Oh, I didn't even noticed that you were someone different. My bad. I will go have it released so I can split...

So sorry....my apologies.
0
mbizupCommented:
Thank you! :-)
0
CeffelAuthor Commented:
No problem at all!! I wish I knew more about how to split points when accepting answers initially. I've had to re-open another question before too because I couldn't find the 'split points' option until it was released back from the administrator.
0
Farzad AkbarnejadDeveloperCommented:
Thanks for points :-)

-FA
0
CeffelAuthor Commented:
No problem.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.