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

Reply
 
Thread Tools Search this Thread Display Modes
Old 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
Click image for larger version

Name:	Screen shot 2011-05-05 at 9.52.52 PM.jpg
Views:	102
Size:	26.3 KB
ID:	284280  
seleneS is offline   0 Reply With Quote
Old May 6, 2011, 05:26 AM   #2
robbieduncan
Moderator
 
robbieduncan's Avatar
 
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...
robbieduncan is offline   0 Reply With Quote
Old 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.
seleneS is offline   0 Reply With Quote
Old May 7, 2011, 03:43 AM   #4
robbieduncan
Moderator
 
robbieduncan's Avatar
 
Join Date: Jul 2002
Location: London
What are you're macro security settings in Excel preferences?
Attached Thumbnails
Click image for larger version

Name:	ExcelMacro.png
Views:	48
Size:	35.0 KB
ID:	284427  
robbieduncan is offline   0 Reply With Quote
Old May 7, 2011, 09:06 AM   #5
MisterMe
macrumors G4
 
Join Date: Jul 2002
Location: USA
Quote:
Originally Posted by robbieduncan View Post
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.
__________________
Neither a borrower nor a lender be
For loan oft loses both itself and friend
William Shakespeare from Hamlet
MisterMe is offline   0 Reply With Quote
Old May 8, 2011, 01:32 PM   #6
seleneS
Thread Starter
macrumors member
 
Join Date: Jul 2010
Quote:
Originally Posted by robbieduncan View Post
What are you're macro security settings in Excel preferences?
The error message shows up for both setting (warning chosen or not)
seleneS is offline   0 Reply With Quote
Old 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
Pyrotechnic is offline   0 Reply With Quote
Old 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.
hanguolaohu is offline   0 Reply With Quote
Old Dec 12, 2012, 12:20 PM   #9
Enzedder
macrumors newbie
 
Join Date: Feb 2012
VBA installation option

Quote:
Originally Posted by seleneS View Post
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.
Enzedder is offline   0 Reply With Quote
Old Dec 12, 2012, 01:10 PM   #10
hanguolaohu
macrumors regular
 
Join Date: Mar 2007
Cool, good to know, thanks Enzedder!
hanguolaohu is offline   0 Reply With Quote
Old Mar 6, 2014, 12:54 PM   #11
cdbeshore
macrumors newbie
 
Join Date: Jul 2008
 
Dymo

hanguolaohu's suggestion worked for me. Turned out that an update to Dymo Label had added something in there.
cdbeshore is offline   0 Reply With Quote
Old Mar 20, 2014, 06:33 PM   #12
hanguolaohu
macrumors regular
 
Join Date: Mar 2007
Glad to hear cdbeshore!
hanguolaohu is offline   0 Reply With Quote

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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
basic formulas do not work when opening Excel files in Numbers? stanw Mac Applications and Mac App Store 3 May 16, 2014 12:16 PM
Visual Basic Module/Macro works in Windows Excel but not Mac Excel 2011 chrispy1042 Mac Applications and Mac App Store 2 May 4, 2014 07:41 AM
Excel Macros stecher Mac Basics and Help 2 Feb 24, 2013 09:33 AM
How to stop Word and Excel constantly opening new documents jbarnes Mac Applications and Mac App Store 9 Jan 5, 2013 09:50 PM
how do I stop word and excel automatically opening when I turn computer on? trek iMac 5 Jun 1, 2012 02:33 AM

Forum Jump

All times are GMT -5. The time now is 05:43 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC