Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How do I activate the visual basic editor in Excel 2007 ?

How do I activate the visual basic editor in Excel 2007 ?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,510
Default How do I activate the visual basic editor in Excel 2007 ?

Click the Office button. (Large button top left)
Select Excel Options (towards bottom right of dialog box)
Select Popular (which is default top left of dialog box)
The check the box for "Show Developer tab in the ribbon"
Close Options and select the Developer tab and you should be able to find
what you want from there.
As an added extra: Alt/F11 still toggles between the VBA editor and
worksheets.

Ensure that you save any workbooks with macros as type
Excel Macro Enabled workbook

--
Regards,

OssieMac


"Coffee" wrote:

How do I activate the visual basic editor in Excel 2007 ?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default How do I activate the visual basic editor in Excel 2007 ?

Alt-F11 works in 2007 as in previous versions.

--
__________________________________
HTH

Bob

"Coffee" wrote in message
...
How do I activate the visual basic editor in Excel 2007 ?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pLeAsE hELp! format function in excel visual basic editor Alpineman2 Excel Programming 4 December 2nd 07 01:19 AM
please help : Excel visual basic editor AMIT Excel Programming 2 March 16th 07 08:01 PM
Visual basic Code or editor won't load in Excel johnsday Excel Programming 2 February 2nd 06 06:00 PM
Can I run Visual Basic procedure using Excel Visual Basic editor? john.jacobs71[_2_] Excel Programming 3 December 26th 05 02:22 PM
Visual Basic editor terminates Excel 2003 Jim Zeeb Excel Programming 3 January 30th 04 08:22 PM


All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"