Restricting User entry in Excel

Mar 5 2008 3:52 PM

Hi,

I have a C# application that writes data into Excel. I need to restrict one column to contain only numerical value.

In Excel, It should not allow the user to enter non-numerical values or should Prompt the user to enter only numerical values. I should achieve this functionality from C#  when I load values to Excel itself. This condition must be stored in Excel and should apply even after disconnecting from C# application.

Regards,
Meena


Answers (1)