excel vba
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA

Excel VBA

resolvedResolved · Low Priority · Version 2003

replyReply Thu 28 May 2009, 15:44Delegate David said...

David has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Excel VBA

The version of Excel where I work does not show the Personal Project in the Project Explorer of the VB Editor. Where can I find it?

For upcoming training course dates see: Pricing & availability

replyReply Mon 1 Jun 2009, 12:56Trainer Carlos said...

RE: Excel VBA

Hi David

The Personal Macro Workbook will only show up on the Project Explorer window if its ever been used to record a macro.

If its not showing on your VB Editor its because no one has ever used your computer's Personal Macro Workbook to store a macro.

So if you record a macro (even with no code) and store it in the Personal Macro Workbook then next time you open the VB Editor the Personal Project will appear.

Hope this helps

Carlos

Mon 8 Jun 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard