Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel Warnings - Macros

09 Nov 2015   #1
WebPixie

Windows 7 Pro 64bit
 
 
Excel Warnings - Macros

I have an Excel Workbook that I use a lot. As far as I know, the workbook doesn't contain any macros but I continue to get this message:
C:\Users\AccountName\Documents\Spreadsheet.xls contains macros.
Macros may contain viruses. It is always safe to disable macros, but if the macros are legitimate, you might lose some functionality.
Then there are buttons to choose from:
Disable Macros...Enable Macros...More Info
The really odd thing is I don't get this warning with other workbooks I've created. This workbook has the same Security Level (medium) as all the other Excel workbooks I've created, so I really don't understand why it's doing this.

How can I get this message to stop?

Thanks in advance!


My System SpecsSystem Spec
.
09 Nov 2015   #2
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit
 
 

How sure are you that it does not contain macros?

Can you make a copy of the file and then enable macros in that copied file? What then happens, if anything? Does the file change in any identifiable way---file size, for instance--anything that might indicate that a macro had actually run?

I don't know if that message can be turned off or if that message is necessarily incorrect.

I use macros in just one of my many Excel files and don't think I've ever seen that message except perhaps on a new installation.

Is this while logged in as the same user as for all other Excel files?

Is the file known to be virus and malware free?
My System SpecsSystem Spec
10 Nov 2015   #3
OfficeNewb

Windows 7
 
 

You can look to see if the document has any macros by going to VIEW -- MACROS -- VIEW MACROS. If there any Macros they would be listed here. Before you delete any macros from this window, make sure you create a copy of the document, just in case those macros did something for the document.
My System SpecsSystem Spec
.

11 Nov 2015   #4
WebPixie

Windows 7 Pro 64bit
 
 

Quote   Quote: Originally Posted by OfficeNewb View Post
You can look to see if the document has any macros by going to VIEW -- MACROS -- VIEW MACROS. If there any Macros they would be listed here. Before you delete any macros from this window, make sure you create a copy of the document, just in case those macros did something for the document.
Perhaps it's because I am using an old version of Excel (Office 2000), but VIEW doesn't have MACRO in the drop-down menu. My only choices are: NORMAL, PAGE BREAK PREVIEW, TOOLBARS, FORMULA BAR, STATUS BAR, HEADER AND FOOTER..., COMMENTS, CUSTOM VIEWS..., FULL SCREEN, and ZOOM...

I can find MACRO> in the TOOLS menu, but that just looks like a place to create a macro (Alt+F8), record a new macro, or change the security level. When I go to RECORD NEW MACRO, the default macro name is "Macro1" That suggests that there are no macros in this workbook - right?
My System SpecsSystem Spec
11 Nov 2015   #5
WebPixie

Windows 7 Pro 64bit
 
 

Quote   Quote: Originally Posted by ignatzatsonic View Post
How sure are you that it does not contain macros?

Can you make a copy of the file and then enable macros in that copied file? What then happens, if anything? Does the file change in any identifiable way---file size, for instance--anything that might indicate that a macro had actually run?

I don't know if that message can be turned off or if that message is necessarily incorrect.

I use macros in just one of my many Excel files and don't think I've ever seen that message except perhaps on a new installation.

Is this while logged in as the same user as for all other Excel files?

Is the file known to be virus and malware free?
I scanned the file with McAfee and it said there were no viruses or other security issues, so that's good. Thank you for the suggestion.

I am logged on as the same user for all of the Excel files, as far as I know. This is the only file where I encounter this issue.
It could be that when I was using Windows XP in 2012 or earlier, I might have been using a different user name for Windows but no specific user names were assigned to the Excel workbook. Could that be an issue if I used a copy of a workbook created in Windows XP to create a new workbook in Windows 7?
When I made a copy of the file and opened it, as you suggested, I did get the same message where I had the option to choose either DISABLE MACROS or ENABLE MACROS. When I chose ENABLE, nothing perceptible changed.

This Excel workbook has a separate spreadsheet for each month plus a few other pages, so it's a bit difficult to detect any subtle changes but I didn't see anything obvious when I made the copy.

I should note that there is another issue with this workbook, but I created separate threads for the two issues in an attempt to keep things simple (Excel Warnings - Links to Other Workbooks). The other issue is that regardless of whether I choose DISABLE or ENABLE for the macros, another message follows that tells me this workbook is linked to another workbook and it gives me the option to update this workbook with changes to the linked workbook - or not. There is no apparent difference with any of the data in this workbook regardless of which option I choose.

It was the same with the copy, followed by another message: If you want to permanently change the source of a link, click Links on the Edit menu, click the link in the list, and then click Change Source.

I did that, but the only option it gave was to change the link from the workbook it had listed to different Excel file. It wasn't possible to eliminate the link. The only options were to link it to a different file or leave it linked to the one listed.

The workbook it has listed is the file I copied from last year to create this year's file. Could I have inadvertently created a link to last year's file when copying it to create this year's?

If so, is there a way to change that? If not for this year's workbook, perhaps when I copy this one to create next year's?

Is it possible that this "link" is the macro?
My System SpecsSystem Spec
Reply

 Excel Warnings - Macros




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Forum for question on Macros in Excel ?
Hello, I am having problems creating a macro in Excel. The keystrokes are not recorded as I expect. Can you advise on the correct section or forum where I should submit my question? Many thanks, Ken
Microsoft Office
Excel 2010 Macros Will Not Run On A New Machine
Am running Win7 and Office 2010. Several years ago I wrote four macros to perform operations in Excel 2010. Thet we to be placed in Personal.XLS so they would be available on all worksheets. I put links to them in the Quick Access bar. Twice I have tried to use those macros on different...
Microsoft Office
enabling macros in Excel
to enable macros in Excel I have to go to Developer then enable macro. Err message ordering me to exit the file, then re-enter it and repeat the "enabling" procedure. This does not always remedy the problem. I have to restart the computer... then go back to my Excel worksheet. However, now...
Microsoft Office
Excel 2003 Macros do not run correctly on a Windows 7 system.
Hi all, I've got a series of Excel 2003 spreadsheets with macros. They run just fine on a Windows XP machine. However, we recently moved them to a Windows 7 Pro machine. We still run them in Excel 2003, only now on a Windows 7 system. Problem is, they don't run right. No errors, but the one...
Microsoft Office
Excel Macros Disabled Under W7
Last week, I received a new notebook with Win 7 professional as OS - :o New to me and I feel way behind time noting the posting dates on the forum. Then there is reference to W8 :shock: I have been developing a program in Excel since 1995, improving the macros and output worksheets as I go along....
Microsoft Office
Running old Excel macros in Windows 7
I have quite a few macros written in older versions of excel that now won't run on our Windows 7 machines. Getting the error that the library is not found. I assume this is an issue with the new "Library" function in Windows 7. Does anyone know what to do to run these? From what I have found,...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 11:53.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App