Sheet construction on server security issue

J

Jim McLeod

Dear group

I am constructing an Excel worksheet on the fly using IIS and .NET. However, I have come across a problem whilst adding checkboxes to the sheet and dynamically setting the OnClick events. Basically the application is throwing a "Programmatic access to Visual Basic Project is not trusted" error.

Is there any way to set the security to allow for this type of development when there is no access to the UI

Regards

Jim..
 
B

Bob Phillips

HI Jim,

XL 2002/3? This is a new security feature that came in in XL2002.

Check it out here http://www.j-walk.com/ss/excel/tips/tip96.htm


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Jim McLeod said:
Dear group,

I am constructing an Excel worksheet on the fly using IIS and .NET.
Click to expand...
However, I have come across a problem whilst adding checkboxes to the sheet
and dynamically setting the OnClick events. Basically the application is
throwing a "Programmatic access to Visual Basic Project is not trusted"
error.
Is there any way to set the security to allow for this type of development
Click to expand...
when there is no access to the UI?
 
Top