Macro shortcut key & security

G

Guest

I have create macro command at work place. I use shortcut key (CTRL+M) to
perform the task. Save it into the doc file. Problem: macro command not
working when I press Ctrl+M at my home pc. But I check the macro, still
inside the document. Why cannot run it, because keyboard?

to enable macro, I should set security to low? must? any other way, because
worried about virus attack.

TQ
param
 
R

Robert M. Franz (RMF)

Hi param
I have create macro command at work place. I use shortcut key (CTRL+M) to
perform the task. Save it into the doc file. Problem: macro command not
working when I press Ctrl+M at my home pc. But I check the macro, still
inside the document. Why cannot run it, because keyboard?

to enable macro, I should set security to low? must? any other way, because
worried about virus attack.

Set it to medium, so each time you open up a template or document
containing VBA code, you are prompted whether you want to allow the code
or not.

OTOH, if it's your macro, you could use the Organizer (Tools | Templates
and Add-Ins, Organizer | Macro) to copy the macro to your normal.dot,
for instance.

HTH
Robert
 
G

Guest

this are the command I used:
running by using keyboard (ctrl+M)
--------------------------------------------------
Sub printreport()
'
' printreport Macro
' Macro recorded 4/1/2006 by param
'
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
End Sub
 
R

Robert M. Franz (RMF)

Param said:
this are the command I used:
running by using keyboard (ctrl+M)
--------------------------------------------------
Sub printreport()
'
' printreport Macro
' Macro recorded 4/1/2006 by param
'
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
End Sub

Did you assign the keyboard shortcut on your home PC, too?

Greetinx
Robert
 
C

Charles Kenyon

Did you save the shortcut into your doc file as well? The default save
location is normal.dot on your work computer.

Security set to medium will be sufficient. When you open the document, you
will be alerted to the presence of macros and given the chance to enable
them (or not).
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 

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