Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macros off
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macros off
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros: can you copy macros from one doc to another? | Excel Discussion (Misc queries) | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions |