How stop Visual Basic macros error message at opening Excel?

seleneS · May 6, 2011, 12:01 AM

I've got this message

"This file contains Visual Basic macros. The macros that have been dislabled."

every time I open Excel, even just opening Excel with no file. How can I stop it? Thanks!

robbieduncan · May 6, 2011, 05:26 AM

Which version of Excel are you running? If it's 2004 that message is probably due to it not support VBA. No idea if it can be turned off but upgrading to the current version that does support VBA would probably get rid of it...

seleneS · May 6, 2011, 11:31 PM

I'm using 2011, version 14.0.2. I think it's the latest version.

robbieduncan · May 7, 2011, 03:43 AM

What are you're macro security settings in Excel preferences?

MisterMe · May 7, 2011, 09:06 AM

Quote:

Originally Posted by robbieduncan

Which version of Excel are you running? If it's 2004 that message is probably due to it not support VBA. No idea if it can be turned off but upgrading to the current version that does support VBA would probably get rid of it...

The OP's posted screenshot is clearly from Excel 2011. Also, Excel 2004 most definitely supports VBA.

seleneS · May 8, 2011, 01:32 PM

Quote:

Originally Posted by robbieduncan

What are you're macro security settings in Excel preferences?

The error message shows up for both setting (warning chosen or not)

Pyrotechnic · Aug 10, 2012, 09:59 AM

Did anyone find a solution, I now have the same issue ?

hanguolaohu · Dec 12, 2012, 12:06 AM

Found the answer on Microsoft Forums.

1. Close Excel.
2. Go to Applications/Microsoft Office 2011/Office/Startup/Excel.
3. If there are any files in the Excel folder, delete them.

Problem solved for me.

Enzedder · Dec 12, 2012, 12:20 PM

Quote:

Originally Posted by seleneS

I've got this message

"This file contains Visual Basic macros. The macros that have been dislabled."

every time I open Excel, even just opening Excel with no file. How can I stop it? Thanks!

I had this issue and found that the VBA Macro option hadn't been installed when Office was first set up. Run the Office setup again and choose the 'Customize' option (about 3rd dialogue window into the routine). Scroll down and look for the VBA option and select it (it should say install), make sure everything else is unticked (skipped). I think you'll find it works after that.

hanguolaohu · Dec 12, 2012, 01:10 PM

Cool, good to know, thanks Enzedder!

May 6, 2011, 12:01 AM	#1
seleneS macrumors member Join Date: Jul 2010	How stop Visual Basic macros error message at opening Excel? I've got this message "This file contains Visual Basic macros. The macros that have been dislabled." every time I open Excel, even just opening Excel with no file. How can I stop it? Thanks! Attached Thumbnails
	0

May 6, 2011, 05:26 AM	#2
robbieduncan Demi-God (Moderator) Join Date: Jul 2002 Location: London	Which version of Excel are you running? If it's 2004 that message is probably due to it not support VBA. No idea if it can be turned off but upgrading to the current version that does support VBA would probably get rid of it... __________________ Sponsor me to cycle 100Km round London in the dark
	0

May 7, 2011, 03:43 AM	#4
robbieduncan Demi-God (Moderator) Join Date: Jul 2002 Location: London	What are you're macro security settings in Excel preferences? Attached Thumbnails __________________ Sponsor me to cycle 100Km round London in the dark
	0

Aug 10, 2012, 09:59 AM	#7
Pyrotechnic macrumors regular Join Date: Feb 2009 Location: United Kingdom	Did anyone find a solution, I now have the same issue ? __________________ 24" 2.9ghz iMac 13" Mac Book Pro 32GB 4S iPhone 80GB iPod 16GB iPad
	0

Dec 12, 2012, 12:06 AM	#8
hanguolaohu macrumors regular Join Date: Mar 2007	The Solution Found the answer on Microsoft Forums. 1. Close Excel. 2. Go to Applications/Microsoft Office 2011/Office/Startup/Excel. 3. If there are any files in the Excel folder, delete them. Problem solved for me.
	0

May 6, 2011, 11:31 PM	#3
seleneS Thread Starter macrumors member Join Date: Jul 2010	I'm using 2011, version 14.0.2. I think it's the latest version.
	0

Dec 12, 2012, 01:10 PM	#10
hanguolaohu macrumors regular Join Date: Mar 2007	Cool, good to know, thanks Enzedder!
	0


MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
thread	Thread Starter	Forum	Replies	Last Post
iTunes stops importing songs.. no error message, just stops. Frustrating!!	fatvince	Mac Applications and Mac App Store	1	Jul 9, 2011 08:09 AM
How do I get rid of the warning message at the opening of Safari?	MrFluffums	Mac Applications and Mac App Store	3	May 22, 2011 02:12 PM
weird iPhoto message at opening	Eldiablojoe	Mac Applications and Mac App Store	2	Feb 15, 2010 02:39 PM
Error message when opening G/band	stigg	Digital Audio	5	Apr 15, 2009 05:25 PM
Error message at startup: How to remove	sunsnewmac	MacBook	1	Oct 25, 2008 11:14 AM