i record macro. when i open it the macro is not working.
it mentioned that i should enable my macro but before i
open the file there is no prompt "enable macro and disable
macro" that we usually see once a file has a macro on it.

please help.
thnx

Set your macro security setting to Medium.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ginger" wrote in message
...
i record macro. when i open it the macro is not working.
it mentioned that i should enable my macro but before i
open the file there is no prompt "enable macro and disable
macro" that we usually see once a file has a macro on it.

please help.
thnx

Looks like you have your security set to HIGH.
TOOLS / MACRO / SECURITY / MEDIUM
HTH,
Gary Brown


"ginger" wrote:

i record macro. when i open it the macro is not working.
it mentioned that i should enable my macro but before i
open the file there is no prompt "enable macro and disable
macro" that we usually see once a file has a macro on it.

please help.
thnx