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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

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

Forum statistics

Threads
1,089,195
Messages
5,406,753
Members
403,105
Latest member
gituncar

This Week's Hot Topics

Top