how to enable macro
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 |
All times are GMT +1. The time now is 01:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com