Enabling Macro for a Single File

lswtic

New Member
Joined
Dec 27, 2010
Messages
6
Hi all,
I was wondering if macro could only be enabled for a single xslm file, but not others. If not, what's the risk of enabling macro, and how can we minimize any potential risks?

Thanks.
 
Last edited:

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

pboltonchina

Well-known Member
Joined
Apr 24, 2008
Messages
1,095
Why don't you put the macro in the specified file instead of your Personal file, then it's only available if you open the specified file.
 

lswtic

New Member
Joined
Dec 27, 2010
Messages
6
How about if i only want the macro on my specific file to be enabled, and all the other macro on other files disabled?
 

lswtic

New Member
Joined
Dec 27, 2010
Messages
6
I think i should just put the file in a separate folder and make the folder a trusted location. Thanks a lot!:biggrin::)
 

Watch MrExcel Video

Forum statistics

Threads
1,090,489
Messages
5,414,838
Members
403,548
Latest member
frostinheart

This Week's Hot Topics

Top