Today we have the second guest post from Sam Radakovitz, Excel Program Manager. Sam is writing about the Trust Centre, a new feature for Office 2007.
Prior to Office 2007 the Office security model has had solid success in helping combat things like macro viruses, but that has come at a price for legitimate macros and for customers who didnât care about macros at all.
To even open a document you first had to âget pastâ a prompt something like the following:
As mentioned the customer needs to âanswerâ this question before moving on to do any work. Letâs explore this a little for a moment from the point of view of the principals outlined in the previous blog post. Itâs certainly secure by default, the code is not enabled, and indeed the only option at first glance seems to be âDisable Macrosâ. It is, however, asking the user a question, and provides some reasonable details â the file name, the fact that the macro signed by Microsoft, etc. And after parsing the text we can figure out that by trusting the publisher we can enable the macros (and by extension the solution flexibility of not being prompted again for macros from this publisher kick in).
However the prompt fails on the principle of keeping the customer productive. In short the user is sitting in Word with no context about the file, which might give a clue to the important question of âdo I l really need to enable the macros to do what I set out to do?â Worse, the user cannot progress until they make a decision, and they must make this decision every time the file is opened. Many customers, faced with this question repeatedly, set their macro security settings to Medium or even Low, exposing themselves to greater risk just to avoid the prompt.
Letâs compare this to the Office 2007 experience. Looking at the screenshot below, the document is opened immediately, and the userâs looking at the workbook. We can read the text of the document and work with it. Instead of the prompt, near the top the document thereâs a notification â the âTrust Barâ â indicating that macros have been disabled and allowing the customer to re-enable them if thatâs desirable.
The customer no longer has a message to answer; they are sitting in the document ready to work. They can read the text and interact with the document, and the Trust Bar notification is there allowing them revisit the secure default decision if they need to run the code.
The biggest change is in productivity â the customerâs expectations are met, the document opens and they can continue with their work. Office quietly enforces a reasonable default security setting and the user has the flexibility to revisit that decision later, when as part of their more normal flow of work they may notice a document or solution isnât working as expected. In many common cases they may never need to interact with the security issue, getting the planned work done without having to make a decision in order to just get the document open.
This experience applies to other common security situations too, including ActiveX controls, application add-ins and extensions etc. where dealing with the security notification is clearly not part of the primary task. Where data integrity requires that the user address a security issue we will still use a modal dialog to ensure the user gets the outcome they want from Office, but in the most common cases Office 12 will just stay out of the way.
The next screen shot below shows what you will see when clicking on âEnable Contentâ in the Trust Bar. Again the path to the relevant file is there, as is the signature evidence, but note that thereâs a little more detail about the signature in the notification as well as some discrete options to just enable the macros or always trust the publisher and have the code run without being blocked in future.
One further issue that has caused confusion for Office customers in the past is that in an attempt to bolt on security after a feature or behavior has proven to include some security threat or risk, engineers have tended to overload an existing security model. A good example is again the VBA Macros case, where in the past Office has âoverloadedâ the VBA macro security model to cover items like Com+ Add-ins, Application add-ins (extensions), even things like updating document data. This, combined with the notion that some âinstalledâ extensions and templates are automatically trusted, has made understanding âwhyâ some document or solutions prompt and some others donât difficult for customers to grasp.
In Office 2007 we have broken down the security models to have very discrete behavior, there are separate settings for VBA Macros, ActiveX control, Application extensions (like Com+ Add-ins etc.) and Trusted Locations for solution documents. The goal here is if the user has to make a decision itâs more transparent what that decision is about.
This clarity combined with being able to review and examine all security decisions associated with the document together in the Trust bar allows the user make a more informed and holistic decision about the trustworthiness of the document, rather than be bullied into it one prompt at a time.
Finally, itâs worth noting that while Office 2007 will greatly reduce the number of security prompts, it would be unrealistic to expect that all prompts will be removed. For technical and indeed usability reasons Office may still ask for a security decision, but this will most likely be in the context of using some feature or extension rather than simply opening a document.