From: hitesh on 14 Jan 2010 02:04
when i open the file in which there is a macros, file open but there is no
is there any idea how to save file with macros.
From: Clarity on 14 Jan 2010 07:41
This is down to your security settings and will depend on which version you
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.
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.
> when i open the file in which there is a macros, file open but there is no
> is there any idea how to save file with macros.
Prev: How can I set up a pop-up calendar for 2010 in Excel?
Next: Excel & Powerpoint lesson plans?