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