Question about Microsoft Office Professional 2007 Full Version for PC
Hi Expert.. I have a sheet, where user have to fill data. There is a column Department.. user should not enter or paste a value other than defined departments. i have applied validation using data>>validation. but it works only if the user selects department from the validation list. but if he copy data from his source and paste it in my Sheet, then the validation doent work. i have created a button (Validation) on the top of the sheet, to validate the data. it validate for email id, contact numbers, name, etc... when the user clicks on this button it throws errors.. the same way it shold throw the error if the department is not in the validation list... please help me out... its urgent
Thanks in advance
Thats a lot of form work to be expecting out of Excel. You might be better off using Access, creating a table. If you need to export it back to a spreadsheet you can. The validation controls are better in Access and don't have a lot of limitations to them.
Good luck on that
Posted on Jul 23, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Apr 15, 2013 | Computers & Internet
Sub sbVeryHiddenSheet() Sheets("SheetName").Visible = xlSheetVeryHidden End Sub
on Dec 09, 2016 | Microsoft Excel for PC
Feb 15, 2013 | Microsoft Excel for PC
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
Feb 21, 2011 | Computers & Internet
Mar 22, 2009 | Microsoft Office Excel 2003 for PC
Jul 08, 2008 | Microsoft Computers & Internet
Feb 05, 2008 | Computers & Internet
Dec 19, 2007 | Computers & Internet
1,889 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: