Enable macros

S

Steved

Hello from Steved

Windows 2000 NT

How do I disable the enables macro function as everytime I
open a workbook it comes up.

Thankyou.
 
F

Frank Kabel

Hi
if your workbook contains macros the only thing would be to set the
security level to 'Low'. But I wouldn't recommend this.

If you think there shouldn't be a macro warning (as you don't have any
macros in this workbook) try the following:
- open the workbook
- open the VBA editor (ALT+F11)
- delete all (empty) modules
- also check the worksheet and the workbook module for code fragments
and delte these statements
-- close the VBA editor, sabe the workbook and try again
 
G

Gord Dibben

Steve

Windows NT is an operating system, not an Office or Excel version.

What version are you running?

Version 97.

Excel 97 macro security is "on" or "off". No levels as 2000 and beyond.

Excel 97 does not support Digital Signatures.

Other than the user turning off the warning in Tools>Options>General there is
nothing that can be done.

In versions 2000 and beyond, macro security has levels from low to high.

Rather than setting security to low, I would use the selfcert tool to create a
didital signature that you would attach to the workbook.

On the other hand, if you mean there are no macros and you still get the
warning, perhaps you have an empty module left over or some lines in a
worksheet or thisworkbook module.

To get rid of that warning, visit Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros

Gord Dibben Excel MVP
 
Top