Macro Warning On Loading A File....

C

clumein2

New Member
Joined
Sep 1, 2006
Messages
32
How do I prevent the macro warning message that appears when loading a file?

Thanks

Cliff
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
Hi,

see the menu Tools/Macro/Security
set to "low" (be aware of the consequences about security !)

kind regards,
Erik
 
Upvote 0
Hi erik,

So I gather it would be wise to leave it and just click 'disable' being that I do not use macros?

And if that's true... is there a way of permanently having it remember my 'disable' choice and not show up again?

thanks
 
Upvote 0
Set your macro security settings to "HIGH", so that no more macros will be run unless you lower the level.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Display message after selecting NO/Cancel when saving file
Replies
6
Views
182
EssKayKay
E
D
  • Question Question
Getting File Not Found
Replies
3
Views
152
NdNoviceHlp
NdNoviceHlp
O
  • Question Question
Annoying Warning
Replies
1
Views
187
MARK858
MARK858
I
  • Question Question
Avoid security message when i go to open Hyperlink on worksheet
Replies
0
Views
177
ipbr21054
I
N
  • Question Question
Repeat macro on multiple files
Replies
1
Views
317
NickvdB
N

Forum statistics

Threads
1,226,240
Messages
6,189,820
Members
453,571
Latest member
Zale

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top