Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Security and other painfull issues
Hi to all!
I need an advice on following - we are developing a piece of software that works with Excel, basically at the end a user would get an excel file with his or her's data. We also allow our users to use macros on the excel file while the file is being created. When the file is being created it is not shown to the user, all of it is done in the background. With Office 2000 we had no problem plugging in the macros, but with Office 2003 our macros get blocked. I am wondering if there is a way to specify that all macros are good, I have been reading on Digital Signing of the VBA code but it is my understanding that it does require the user to "OK" the macro prior to using it, in this case it is impossible as the user does not see the file until it is finished being created. I guess the idea is to go back to the level of security of the Office 2000? Any help on how it might be accomplished is greatly appreciated Paul. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Security and other painfull issues
Hi Paul,
This has been discussed a few times recently on the NG so I would have a look through the old posts. To start you off have a look at this one: http://groups-beta.google.com/group/...84c7b570a2d16c {Watch for wrapping!) HTH, Gareth paul wrote: Hi to all! I need an advice on following - we are developing a piece of software that works with Excel, basically at the end a user would get an excel file with his or her's data. We also allow our users to use macros on the excel file while the file is being created. When the file is being created it is not shown to the user, all of it is done in the background. With Office 2000 we had no problem plugging in the macros, but with Office 2003 our macros get blocked. I am wondering if there is a way to specify that all macros are good, I have been reading on Digital Signing of the VBA code but it is my understanding that it does require the user to "OK" the macro prior to using it, in this case it is impossible as the user does not see the file until it is finished being created. I guess the idea is to go back to the level of security of the Office 2000? Any help on how it might be accomplished is greatly appreciated Paul. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro security | Excel Discussion (Misc queries) | |||
Macro security issues | Excel Discussion (Misc queries) | |||
SECURITY ISSUES | Excel Discussion (Misc queries) | |||
Macro Security | Excel Discussion (Misc queries) | |||
Excel VBA, VBS and Network Security Issues | Excel Programming |