Security Warning to enable or disable macros

[Chuck]

On a few spreadsheet which one particular employee has
worked on are giving a Security Warning to enable or
disable macros. Yet when in the spreadsheet, it appears
that there aren't any macro nor any links. The employee
has mentioned that in certain instances, his computer
locks up when he tries to save or print preview these
particular spreadsheets. Does anyone have any insight
into this problem?

 

[Frank Kabel]

Hi Chuck
Some ideas why the security warning appears:
- (empty) code modules exist
- code within the worksheet or workbook modules

Have a look at
http://www.contextures.com/xlfaqMac.html#NoMacros
for instructions how to remove this and to 'disable' the security
warning

 

[Kent]

If it happens to one user but not the others it may be the
security is set to "High" as well. I like Frank's response
about the possibility of an empty module but it could also
come down to simply setting the security down a notch
to "Medium" -- Tools->Macro->Security