edit vba code in excel

Some functions and formulas are often used when you tab in Excel, and you return some error codes if you use them incorrectly. Of course, the reason for these error codes is often the result of our operation error, we can according to the wrong agent in Excel to analyze the specific reasons, so as to accurately solve the problem! We've already analyzed several common error codes, and today we'll talk about

We entered a number of function formulas in the Excel cell, gave the form to others, and feared that she accidentally changed the function, resulting in the subsequent calculation of the data error. How do I lock these cells? So that it cannot be modified? The method of using macro code can be accomplished. ① we open the Excel2013, press the ALT+F11 key on the keyboard to bring up the

Most of the Excel.Application (http://www.blueidea.com/tech/program/2006/3547.asp) components are used to generate Find error prone, and for most of the rookie like me, more trouble, considering the previous days with asp+ template +adodb.stream generation static page method, after many attempts, finally mastered a asp+ template to generate Excel and Word, the new way to share the following: Use templates to build

= true; This. Maid [7]. Visible = true; This. Maid [This. Maid. Count-1]. Visible = false ;//* This. Maid [This. Maid. Count-2]. Visible = false ;//* This. datagrid1.allowsorting = false ;//* This. Maid = false; This. Maid =-1 ;//* This. bindgrid (); This. exportexcelfromdatagrid (filename, this. datagrid1 ); } } The principle is to use the rendercontrol method of the DataGrid (actually its parent class control) to output the HTML code into the buffe

1. Open an encrypted EXCEL File2 tool --- macro ---- recording new macro --- input name such as aa3. Stop recording (an empty macro is obtained)4 tools --- macro ---- macro. Select aa and click Edit.5. Delete All characters (only a few characters) in the window and replace them with the following code.6. Close the editing window.7 Tools --- macro ----- macro, sel