Thread: Unable to Draw a Grid Control:: not trusted.

The subject is not trusted for the specified action.

I have an add-in I created a few years ago and has always worked fine until upgrade to Office 2007 Pro. The user form acts as wizard utilizing a mulitpage control with three pages. Anyway, the third page had a grid that for some reason literally disappeared from the form. No problem - I just establish the grid - all the code is yet pristine - it should work fine.

The problem is every time I attempt to draw the grid on the form the warning quoted above is displayed. Which is pretty much gibberish. I have all the uber paranoid trust center stuff turned off or at least every folder and subfolder on my system listed as [trust]worthy.

So, wtf is up with this? Any ideas?

TIA

http://www.tek-tips.com/viewthread.cfm?qid=1530759

I found the link above. It seems when I created the add-in I had VB6.0 on my machine which has since been replaced with VS2007 - I think. At any rate, VB6.0 is no longer on my machine.

Running the dos command

del c:\*.exd /s

did fix the problem - the grid is back. The article referenced above explains an MS 'fix' in 2008 created the problem.

Well that didn't last long. Gone again!

Could this be the problem?

http://support.microsoft.com/kb/282830

I have Enable all macros option checked and Trust access to the VBA project object model chekbox checked.

I believe now it has to do with the fact there (apparently) are no Grid Controls available to Excel and Access User Forms and the MSFlexGrid control I used, is only licensed to VB6.0 project use or to applications resident to the machine VB6.0 is installed.

I suppose I could reload my licensed copy VB6.0 but then my Add-In would only function on this machine. I remedied the situation by using text boxes - which sucks!

I'll keep looking for a Grid solution though.