Unwanted macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kitty2@officeformac.com - 02 May 2008 21:35 GMT

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I have a complicated excel system using macros in excel.

But I have noticed that now in my word application, the macros have appeared. And when sending doc's to people, they get messages from their servers that think my doc's have viruses as they have macros. I do not want these macros in word, I only want them in my excel documents. Why has this happened and how can I stop them in Word.
In fact I would rather have the macros only in the selected documents that I choose - not every excel doc that I open - the default should have no macros!

Another problem that I'm having is that all my word doc's are a 'read only' and I have looked in preferences under the security and unticked the 'read only' box but still this continues.

Can you help ???

MacBook Pro Mac OS X (10.4.10)

Reply to this Message

Carl Witthoft - 03 May 2008 20:22 GMT

> Version: 2004
> Operating System: Mac OS X 10.4 (Tiger)
[quoted text clipped - 17 lines]
>
> MacBook Pro Mac OS X (10.4.10)

Did you ever embed an Excel document into a Word doc? I'm not sure but
that might lead to Excel macros being detected in the document.

As to Excel in general: your global macros are stored in "modules"
inside something called "default" or "personal macro workbook."

Open the Visual Basic Editor (after opening the Excel document you want
the macros to be inside of). Click on the Module under the
"Personal...." tree. Cut out all the code (Control-X, that is, or
equivalent). Click on the icon for the document you are working with,
and select New Module from one of the menus.
Paste all the macro code into that module.

that should do it.

Carl

Signature

Team EM to the rescue! http://www.team-em.com

Reply to this Message

Mac Forum / Applications / Excel / May 2008

Unwanted macros