An MS Office (2007) question for system admins

[88keys]

I'm working a somewhat complicated spreadsheet for work and I need to come up with (often daunting) task making the data entry side of it simple while still being able to perform the complex functions that it needs to so that the less computer savvy people can effectively use it.

That being said, I have a script (which I use for myself) that I can adapt to this spreadsheet which will nice and neatly perform all of the functions it needs to and it's set up so that a monkey can do it. The problem that the stupid warning for vb/macros will come up everytime if I do it this way. Normally this wouldn't be an issue if it were used by a small group of people, but from what I understand this will be utilized by nearly everyone with computer access to some extent so it's very important that it is both fluent and functional.


TL;DR start here:


All of that being said, is there a way to have a spreadsheet digitally signed on Windows Server network with Office 2007 so that the macro/vbscript warning doesn't come up.

I can probably find a way to do this without a script, but i would be cumbersome for me and result in a much more bloated spreadsheet file.

 

[mikeymikec]

For MS Access IIRC there's a "trusted locations" UI that you can add database apps to so that the additional warning(s) are avoided. Is this available somewhere in Excel's options?

 

[Dahak]

In Excel go to the Orb -> Excel Options -> Trust Center -> Trust Center Settings and the Trusted Locations settings.

Here you can specify the location of the file and it should stop the warning