applying rules to Excel Sheets using Macros
 

Hi ,
I'm new to this.
I have a Excel Sheet with given columns and rows with some restrictions
on the data.
I need to do the following:

1.Given Columns,Rows should be maintained
2.VAlues of R/C should be restricted
3.Internal conflicts in the workbook should be managed

**Whenever some one tries to violate these rules they should either be
warned or not allowed.


4.Calling tools with given file as parameters to generate required
files.

All this has to be done programmatically.

applying rules to Excel Sheets using Macros
 

Hello,

Problems 1-3 ask for a combination of Protection (Tools menu) and Validation
(Data menu), I think. I don't think you need any programming. (For further
questions about this, look in another Excel group.)

Problem 4 isn't clear to me - you should describe this more extensively.

Hope this helps a little bit,
Greetings,
Peter


" wrote:

Hi ,
I'm new to this.
I have a Excel Sheet with given columns and rows with some restrictions
on the data.
I need to do the following:

1.Given Columns,Rows should be maintained
2.VAlues of R/C should be restricted
3.Internal conflicts in the workbook should be managed

**Whenever some one tries to violate these rules they should either be
warned or not allowed.


4.Calling tools with given file as parameters to generate required
files.

All this has to be done programmatically.