Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / September 2006



Tip: Looking for answers? Try searching our database.

How to remove Excel 4 macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
scott.siegler@gmail.com - 11 Sep 2006 17:13 GMT
Hello,

I run Office 2004 on my Mac.  For some reason when I try to open some
files, I get the dialogue box asking me if I want to enable macros.  I
have included no macros in the file.

I then went into VB editor and openened all object and this workbook
and everything is blank.

Something I noticed is that if I originally say to disable macros, I
get an error saying there are Excel version  4 macros which cant be
disabled.  So, I take it these are the macros that are causing my
problem.

Does anyone know where or what these version 4 macros are?  Is there
any way for me to remove them?

thanks,
Scott
Bob Greenblatt - 18 Sep 2006 15:31 GMT
On 9/11/06 12:13 PM, in article
1157991188.376920.271920@q16g2000cwq.googlegroups.com,

> Hello,
>
[quoted text clipped - 15 lines]
> thanks,
> Scott

Scott,

There may actually be no macros in the workbook. I have seen this problem
occur when a workbook, originally created in windows that had Active-x
controls was transferred to the Mac. There is some remaining file corruption
that causes this issue. Try saving each worksheet individually in some other
form such as SYLK. Then reassemble the individual worksheets back into the
workbook and save again.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.