VB in MS Word, Skip Prompts..?
Posted on 2006-03-21
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,