Enabling macros
I have a worksheet with some UDFs, and each time I open the worksheet, I get
a dialogue box asking if I want to enable macros. I click yes, and no problem. However, I just updated Office 2000 from the MS update site, and now the dialogue box asking if I want to enable macros NO LONGER appears when I open the worksheet. Consequently, the UDFs don't work. When I change an argument to the UDF, for exmaple, I get an error message saying that macros are not enables. So, how do I enable macros, now that I no longer get the enable macros box when i open the worksheet? -- Thanks for any help |
hi,
check your security and make sure it isn't set to low. toolMacrosecurity -----Original Message----- I have a worksheet with some UDFs, and each time I open the worksheet, I get a dialogue box asking if I want to enable macros. I click yes, and no problem. However, I just updated Office 2000 from the MS update site, and now the dialogue box asking if I want to enable macros NO LONGER appears when I open the worksheet. Consequently, the UDFs don't work. When I change an argument to the UDF, for exmaple, I get an error message saying that macros are not enables. So, how do I enable macros, now that I no longer get the enable macros box when i open the worksheet? -- Thanks for any help . |
hi again.
that should be isn't set to high. sorry. -----Original Message----- I have a worksheet with some UDFs, and each time I open the worksheet, I get a dialogue box asking if I want to enable macros. I click yes, and no problem. However, I just updated Office 2000 from the MS update site, and now the dialogue box asking if I want to enable macros NO LONGER appears when I open the worksheet. Consequently, the UDFs don't work. When I change an argument to the UDF, for exmaple, I get an error message saying that macros are not enables. So, how do I enable macros, now that I no longer get the enable macros box when i open the worksheet? -- Thanks for any help . |
thanks for your help. i will check it out
" wrote: hi again. that should be isn't set to high. sorry. -----Original Message----- I have a worksheet with some UDFs, and each time I open the worksheet, I get a dialogue box asking if I want to enable macros. I click yes, and no problem. However, I just updated Office 2000 from the MS update site, and now the dialogue box asking if I want to enable macros NO LONGER appears when I open the worksheet. Consequently, the UDFs don't work. When I change an argument to the UDF, for exmaple, I get an error message saying that macros are not enables. So, how do I enable macros, now that I no longer get the enable macros box when i open the worksheet? -- Thanks for any help . |
All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com