Prev: How can I set up a pop-up calendar for 2010 in Excel?
Next: Excel & Powerpoint lesson plans?
From: hitesh on 14 Jan 2010 02:04
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.




From: Clarity on 14 Jan 2010 07:41
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.
>
>
>
>
 | 
Pages: 1
Prev: How can I set up a pop-up calendar for 2010 in Excel?
Next: Excel & Powerpoint lesson plans?