Hi

Firstly I think you may try to do it from VBA.
You can record the macro that format on a protected sheet to see if that
works, and observe the code generated by Macro Recorder to see what it is
doing.
And then change the code accordingly in VSTO to see if that works.



Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.