asked on

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

ASKER CERTIFIED SOLUTION

Farzad Akbarnejad

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Ceffel

ASKER

Ok, that isn't working for some reason. It continues to prompt me even after I removed that selection.

Thanks,
CE

SOLUTION

mbizup

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Ceffel

ASKER

Ok, that worked. Thank you very much for your help!!!

mbizup

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...

Ceffel

ASKER

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.

mbizup

Thank you! :-)

Ceffel

ASKER

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.

Farzad Akbarnejad

Thanks for points :-)

-FA

Ceffel

ASKER

No problem.