Back to: Excel VBA . Got any Excel/VBA Questions? Excel Help
Push Alt + F11
Push Alt + F11 to toggle between Excel and the VBE.
or Alt + Q to quit the VBE.
While in Excel Right click on the Excel icon, top left next to "File" and select "View Code". Then choose an Event from the "Procedure" drop down list box. For Excel 2000 you will need to select "Workbook" from the "Object" drop down list box.
Right click on any sheet name tab and select "View Code". Then choose an event from the "Procedure" drop down list box. For Excel 2000 you will need to select "Worksheet" from the "Object" drop down list box.
Place you mouse insertion point anywhere within the text and push F1.
Right click on any blank area of the Toolbar and select "Customize" then click the "Commands" page tab and drag menu items on or off.
Go to Tools>VBAProject Properties... select the "Protection" page tab, check the "Lock project from viewing" check box. Type in a password in the "Password" box then type in again in the "Confirm password" box. and click Ok. You will need to Save and close the Workbook for the protection to take place.
Degree symbol = Alt+0176
At sign = Alt+064
Copyright sign = Alt+0169
Registered symbol = Alt+0174
One quarter as a fraction = Alt+0188
One half as a fraction = Alt+0189
British Pound sign = Alt+0163
Three quarters as a fraction = Alt+0190
To get the full list type "Character Set (128 255)" into the help wizard while in the VBE
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates