Step one, set macro levels of security for "low"

2011-03-14 08:50

 

Open the Excel, in turn, choose "tool - macro - Visual Basic editor", "in the Visual Basic editor" choose "he insertion - in module", in the window input three lines of code: sub macrodm (), MsBox "macro", End wish sub (code after without punctuation). Then ordinal select file - closed Microsoft Office 2010 is so great.

and return to Microsoft Excel ", save and closed the current Excel file. Then again open up files, appear safety warning, indicating that the macro is disabled, then we must in turn choose "guide-explore-design-grasp macro - security" tool properites dialog, will "macro" safety level set to "low", and click "ok" save. Office 2010 is my favorite.

Step 2, install VBA project of digital certificates

Access the control panel - add or remove programs - to change or delete program ", on the right to find "Microsoft Office does happen 2003" and click on "change", then there will be "Microsoft Office 2003 installation", in turn, choose "add or delete function - next", select the "select Microsoft outlook 2010 is convenient!

applications of senior custom check box and click" next "and the" version of sharing function ", click the VBA project of digital certificate "left arrow in the list, and then click the" from the machine running order ", and finally click "update", insert Office installation disks start the installation. Microsoft Office is helpful.

Step 3, create your own digital certificates

265IT (https://www.265it.com) reminder after the success of the installation. In Microsoft Office startup code menu in turn choose "Microsoft Office tools - VBA project of digital certificate", in the pop-up "create digital certificate" dialog box "your certificate name" box, type in the name of digital certificate, click "ok" was created his own digital certificates. Outlook 2010 is powerful.

Step four, for macro add signature

Open step 2 created files, in turn, choose "tool - macro - Visual Basic editor", in the editor again ordinal choice "tool - digital signature", "in the digital signature" dialog box, click the "choose" button, choose steps 4 digital certificates, and create "ok" to return. Then ordinal select file - closed and return to Microsoft Excel ", save and close the file. Office 2007 can make life more better and easier.

 


Make a website for free Webnode