Enable macros

[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.

 

[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

 

[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

 

[Debra Dalgleish]

If you don't think the workbook has any macros, you can follow the
steps shown here to get rid of the warning:

http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Steved]

Hello from Steved.

Folks it is now fixed thanks to your efforts.

Cheers.

 

[Steved]

Hello from Steved.

Folks it is now fixed thanks to your efforts.

Cheers.

 

[Gord Dibben]

Steve

Just curious. What was the fix?

Gord

Hello from Steved.

Folks it is now fixed thanks to your efforts.

Cheers.