Hi,

This is down to your security settings and will depend on which version you
are using.

In 2007 you are able to save a file as a macro enabled file & security is
managed through the Trust settings. (Excel options/Trust Centre)

You should normally receive notification that a file has a macro and be
asked whether or not you want to enable it.


In 2003:

Click "Tools" - "Options".

Select the "Security" tab.

Select "Macro Security".

Select the "Security level" tab.

Choose the macro security level.

You will then need to restart Excel before opening your file.

Myles
"hitesh" wrote:

Dear

when i open the file in which there is a macros, file open but there is no
macros.
is there any idea how to save file with macros.

pls

help.