Sheet construction on server security issue

[Guest]

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..

 

[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)

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?