Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel security
hallo!
I have some Excel 2003 SP3 procedures opening .xls files, each of them containing VBA macros. In order to provide the highest system protection, each time Excel requires repeatedly user permission to open, which is tedious and in sometimes problematic. I wonder if there is a way to bypass this process, by notifying excel that those specific files are safe (by file names o author). Otherwise I'm obliged to keep the protection level to "low", but in such a case my sistem will be exposed to damage risk from other "unknown" macros. thanks for reply |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel security
Try self-certifying those workbook.
See http://www.vbaexpress.com/forum/show...ht=SELCERT.EXE -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Romolo" wrote in message ... hallo! I have some Excel 2003 SP3 procedures opening .xls files, each of them containing VBA macros. In order to provide the highest system protection, each time Excel requires repeatedly user permission to open, which is tedious and in sometimes problematic. I wonder if there is a way to bypass this process, by notifying excel that those specific files are safe (by file names o author). Otherwise I'm obliged to keep the protection level to "low", but in such a case my sistem will be exposed to damage risk from other "unknown" macros. thanks for reply |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel security
Thanks a lot, Bob
-- grazie, Romolo "Bob Phillips" wrote: Try self-certifying those workbook. See http://www.vbaexpress.com/forum/show...ht=SELCERT.EXE -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Romolo" wrote in message ... hallo! I have some Excel 2003 SP3 procedures opening .xls files, each of them containing VBA macros. In order to provide the highest system protection, each time Excel requires repeatedly user permission to open, which is tedious and in sometimes problematic. I wonder if there is a way to bypass this process, by notifying excel that those specific files are safe (by file names o author). Otherwise I'm obliged to keep the protection level to "low", but in such a case my sistem will be exposed to damage risk from other "unknown" macros. thanks for reply |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel security
An Excel VBA procedure should be able to open a workbook that contains code,
without the macro warning. Having already approved opening of the workbook with the VBA, or writing fresh VBA, provides implicit acceptance of the macros in the unopened workbook. The warning that's harder to avoid is a prompt to update any links in the workbook being opened. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Romolo" wrote in message ... hallo! I have some Excel 2003 SP3 procedures opening .xls files, each of them containing VBA macros. In order to provide the highest system protection, each time Excel requires repeatedly user permission to open, which is tedious and in sometimes problematic. I wonder if there is a way to bypass this process, by notifying excel that those specific files are safe (by file names o author). Otherwise I'm obliged to keep the protection level to "low", but in such a case my sistem will be exposed to damage risk from other "unknown" macros. thanks for reply |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Security Excel | Excel Worksheet Functions | |||
Excel & Security | Excel Discussion (Misc queries) | |||
Excel Security | Excel Discussion (Misc queries) | |||
Excel Security?? | Excel Discussion (Misc queries) | |||
Excel security problem | Excel Discussion (Misc queries) |