Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off Macro Warning
I wrote a small macro for a worksheet. Every time I load the
workbook into memory --there is only one worksheet in it-- a window pops up asking me whether or not I want to run the macro. Is it possible to turn off the macro warning window for a specific workbook (or worksheet) with some VBA line of code? How? ---- Tiziano |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off Macro Warning
Nope. It depends on the Macro Security Level the user has set. Ofcourse this cannot be set with code.. it would defeat it's purpose wouldn't it.. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Tiziano wrote : I wrote a small macro for a worksheet. Every time I load the workbook into memory --there is only one worksheet in it-- a window pops up asking me whether or not I want to run the macro. Is it possible to turn off the macro warning window for a specific workbook (or worksheet) with some VBA line of code? How? ---- Tiziano |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off Macro Warning
In Excel 2000, goto "Tools", "Macros", "Security" and set
to "Low". In Excel XP Pro, goto "Tolls", "Options", "Security". -----Original Message----- I wrote a small macro for a worksheet. Every time I load the workbook into memory --there is only one worksheet in it- - a window pops up asking me whether or not I want to run the macro. Is it possible to turn off the macro warning window for a specific workbook (or worksheet) with some VBA line of code? How? ---- Tiziano . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off Macro Warning
keepITcool wrote:
Nope. It depends on the Macro Security Level the user has set. Ofcourse this cannot be set with code.. it would defeat it's purpose wouldn't it.. Get a digital signature. You could use something expensive like from Verisign, or if it's just for personal use, locate selfcert.exe on the Office installation cd and search the Excel help for more info. It's in there, really! -- To top-post is human, to bottom-post and snip is sublime. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to turn off the popup warning when clicking on a hyperlink | Excel Worksheet Functions | |||
How do you turn off sort warning in Excel 2003? | Excel Discussion (Misc queries) | |||
How do I turn off the clipboard warning when a file is closed? | Excel Discussion (Misc queries) | |||
How to turn off warning when hyperlinking to other program? | Excel Discussion (Misc queries) | |||
Turn Off Warning in Macro | Excel Programming |