Frustration with privacy settings and Macros

[Taemex]

I'm a little bitter right now and upset so here's mt OT-rant in quotes with the TL;DR version at the bottom:

It seems of our fifteen work locations, all of our office PC's have Excel 2010 with security set to high. This is a good thing, as some of our users are, to put it gently, computer retarded. This, however is presenting a real challenge for me. On my first attempt to get my worksheet to open (for our company), Excel gave a warning from the Trust Center without any option to Enable Macros... It took the better half of an hour to figure out I had to hit the Office Sign/Options/Trust Center/Trust Center Settings/Trusted Locations... then add my desktop folder. Only then could I load my document with a warning at the top giving me the option to enable macros. There is no other way to even give the option to enable macros until the location is a trusted one. This is so nuts! Isn't there a way to trust a publisher without having to pay $150 annually for a ssl certificate? This seems like a true scam to me. Whats to stop some script kiddy from getting an authentic license and distributing trojaned worksheets?

I find this most absurd because my vb.net code did the exact same thing this workbook does; only only reason I switched over was Excel objects kept staying in memory when called as COM objects, I was too lazy to add code passwording / unpasswording the sheet for every button press, and I still had trouble hiding all Excel display headings and getting them back without deleting Excel14.xlb in Roaming, however I could have eventually worked out these kinks. The main roadblock was discovering that to use my program, my clients needed would of had to download a separate .Net SP3 add-on, which would have required me to include that file in my distributable, and write a batch file as an installer to make sure these users didn't mess it all up. This was the point I decided I was already familiar enough with vba from previous dabblings to remake my workbook in record time with all the features I wanted but half the hassle...

And now this!!! I could easily distribute my vb.net executable freely without any warning to my clients. If I were a douche, I guess could have trojaned the baloney out of that without any problems or warnings. But now here I am trying to run a legitimate program on my work computers and it won't even run without a marathon session of directions to follow before the warning even pops up giving the option to use macros with said workbook. And to add injury to insult, once this miracle is accomplished (a true miracle with the poor, computer illiterate saps I work with), they have to choose to enable the macros each and every time they use my workbook?!?

TL;DR: How can my business keep the Macro and Active X security settings high, yet allow workbooks from my PC (or at least this one) to be trusted without purchasing ssl certificates?

[:) Sixthsense :)]

Not sure if I understand it perfectly,

What about adding the Macro Files Folder in Trusted Location, so that the Security won't be a constraint

[Taemex]

Because my users would have difficulty figuring that out, i.e. how to navigate the trust center. They are floor managers without a grain of computer knowledge amongst the lot of them. No matter, I found an easy solution. Apparently when you open a workbook with vb.net, it bypasses all security bullsh... and opens the document, macros and all. Just tested it on two separate computers that won't open my workbook, but do it fine with my program.

Here is the code I wrote in 5-minutes with vb.net if anyone is interested:

Please Login or Register  to view this content.

Just add a reference to COM object Microsoft Excel 14.0, Build, and you're good to go, nothing on the form. Tell your user to open their workbook using the .exe.