Unwanted macros

K

Kitty2

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)
 
C

Carl Witthoft

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)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top