#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros: can you copy macros from one doc to another? Roady Excel Discussion (Misc queries) 1 June 12th 08 05:47 PM
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Macros warning always shows up, even if all macros removed Joe M Excel Discussion (Misc queries) 1 December 20th 07 04:45 AM
Macros - copying macros from one computer to another TT Excel Discussion (Misc queries) 18 December 14th 06 03:24 AM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM


All times are GMT +1. The time now is 03:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"