Excel 2007 Macro Question

G

Guest

Hi,

I just had Excel 2007 installed on my laptop today and for some reason the
macro section is greyed-out. I'm not able to view or create any macros. Can
anyone tell me why?
 
B

Bob Flanagan

Most likely VB is not installed. Check in Control Panel, add/remove
programs, Office, add or remove features.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
G

Guest

Yes, I don't see it listed. Should VB of been installed automatically when
Excel 2007 was installed? Does it come with Excel 2007? How do I fix the
problem?
 
B

Bob Flanagan

Under one of the the Office settings in Control panel, add or remove
programs, Office, add or modify is an option to install VB as part of
office. I think it may be under the Office Shared Features section. Change
the selection in it to installed or install on first use. Unfortunately, I
can't be more specific as there are many versions of Office and mine has VB
installed and no options.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
J

Jim Rech

Should VB of been installed automatically when Excel 2007 was installed?

I think so. But MS does not unfortunately.

--
Jim
| Yes, I don't see it listed. Should VB of been installed automatically when
| Excel 2007 was installed? Does it come with Excel 2007? How do I fix the
| problem?
|
| "Bob Flanagan" wrote:
|
| > Most likely VB is not installed. Check in Control Panel, add/remove
| > programs, Office, add or remove features.
| >
| > Bob Flanagan
| > Macro Systems
| > http://www.add-ins.com
| > Productivity add-ins and downloadable books on VB macros for Excel
| >
| > | > > Hi,
| > >
| > > I just had Excel 2007 installed on my laptop today and for some reason
the
| > > macro section is greyed-out. I'm not able to view or create any
macros.
| > > Can
| > > anyone tell me why?
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL 2007 Macro Security Being Ignored 9
Enabling Visual Basic in Excel 2007 1
Excel 2007 Macro use in Windows 7 Home 5
Excel 2007: Help creating a macro that will run Solver? 3
Excel Macro-enabled Workbook 2
Macro security in 2007 5
Opening a Macro in Excel 2007 1
Problem (bug?) in the way Excel 2007 doesn't automatically load ma 8

Top