Y
ykffc
Our Win 2003 terminal server was installed with Office 2003. I want to allow
users to run Office applications through RDP (remote desktop). Using the
standard Office tools I can create a self-signed certificate when the machine
is logon as, say adminX. Then still logging on as adminX, I can design
Access/Excel applications containing VBA codes and these VBA projects can all
be signed using the self-signed certificate of adminX.
Question 1: Is there a way to stop every normal user to run VBA codes except
those signed with the certificate of adminX?
Question 2:
Then I try to figure out whether it is possible to enforce macro security
level being "High security" for every user. I mean for every user logging
onto this machine (through RDP), the system will select High Security for
them automatically. I have read the following article trying to find an
answer:
http://office.microsoft.com/en-us/ork2003/HA011403071033.aspx,
in which it wrote:
------------------------
.....Administrators can set the macro security level by using the Specify
Office Security Settings page of either the Custom Installation Wizard or the
Custom Maintenance Wizard. These settings will be applied when Office is
either installed or a maintenance update is applied.....
---------------------
I tried to run the Custom Maintenace Wizard (since Office 2003 was already
installed by selecting 'typical install', I download and in install the
resource kit for Office). To my surprise it seems there is no way to walk to
the "Specify Office Security Setting page". Later I tried the Custom
Installation Wizard but is the same, I can't figure out how to go to "Specify
Office Security" page. Do I miss anything?
Note once more: I am not asking how to set macro security in the user level.
The answer was already written in the above web-page, namely by clicking on
Tools, pointing to Macro, and then clicking Security; or by clicking Tools,
clicking Options, and then clicking the Security tab. But my question is, is
there ways to bypass that question? For example, after a user copies say, an
Excel file from his local PC to the server and he/she opens the file in which
there is a macro. I don't want Office to ask the security level setting
question, not even when he/she is a first time user of Office or not. I want
the user to be able to open the Excel file but the system simply refuses to
run any macro without complaint or prompting.
Thank you for your patience to read this long post.
users to run Office applications through RDP (remote desktop). Using the
standard Office tools I can create a self-signed certificate when the machine
is logon as, say adminX. Then still logging on as adminX, I can design
Access/Excel applications containing VBA codes and these VBA projects can all
be signed using the self-signed certificate of adminX.
Question 1: Is there a way to stop every normal user to run VBA codes except
those signed with the certificate of adminX?
Question 2:
Then I try to figure out whether it is possible to enforce macro security
level being "High security" for every user. I mean for every user logging
onto this machine (through RDP), the system will select High Security for
them automatically. I have read the following article trying to find an
answer:
http://office.microsoft.com/en-us/ork2003/HA011403071033.aspx,
in which it wrote:
------------------------
.....Administrators can set the macro security level by using the Specify
Office Security Settings page of either the Custom Installation Wizard or the
Custom Maintenance Wizard. These settings will be applied when Office is
either installed or a maintenance update is applied.....
---------------------
I tried to run the Custom Maintenace Wizard (since Office 2003 was already
installed by selecting 'typical install', I download and in install the
resource kit for Office). To my surprise it seems there is no way to walk to
the "Specify Office Security Setting page". Later I tried the Custom
Installation Wizard but is the same, I can't figure out how to go to "Specify
Office Security" page. Do I miss anything?
Note once more: I am not asking how to set macro security in the user level.
The answer was already written in the above web-page, namely by clicking on
Tools, pointing to Macro, and then clicking Security; or by clicking Tools,
clicking Options, and then clicking the Security tab. But my question is, is
there ways to bypass that question? For example, after a user copies say, an
Excel file from his local PC to the server and he/she opens the file in which
there is a macro. I don't want Office to ask the security level setting
question, not even when he/she is a first time user of Office or not. I want
the user to be able to open the Excel file but the system simply refuses to
run any macro without complaint or prompting.
Thank you for your patience to read this long post.