Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros running with Validation Rules | Excel Worksheet Functions | |||
applying COUNTIF formula across several sheets | Excel Discussion (Misc queries) | |||
applying formulas for all sheets selected | Excel Worksheet Functions | |||
Applying multiple distinct conditional formatting rules | Excel Discussion (Misc queries) | |||
Applying Protection To Multiple Sheets | New Users to Excel |