Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Worksheet Functions |