Re: $$Excel-Macros$$ enable Data Validation & Insert menu in Developer menu

2014-05-29 Thread Vaibhav Joshi
Hi Please refer the following options to enable data validation- 1. Saved the Excel spreadsheet to your desktop. 2. Open the spreadsheet 3. Select Review (6th Tab from the left)-options are applicable for Office 2007. 4. Click on Share Workbook 5. Uncheck the option named as "Allow chan

Re: $$Excel-Macros$$ enable Data Validation & Insert menu in Developer menu

2014-05-29 Thread Vaibhav Joshi
Hi 1) Check whether workbook is protected or not?? 2) Check the setting for View objects. Office Button > Excel Options > Advanced > Display Options for this workbook For objects, show: All 3) You might have set Disable all controls without notification in the ActiveX settings for all applicat

$$Excel-Macros$$ enable Data Validation & Insert menu in Developer menu

2014-05-29 Thread Ashish Bhalara
Dear experts, I want add command button but somehow Insert menu turn to disable in Developer menu, the Data Validation also not work, kindly know me how reset it. Thanks & regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental ΓΌ