Unable to access any Programming capability

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Redbreva - 23 Jan 2008 07:50 GMT

I am using Excel 2007, and have previously written, and used. several
macro's on this machine. Recently, however, the 'Visual Basic', 'Record
Macro' etc icons have been grayed out, and I am unable to access the
"programmin" portion of Excel.

I have searched the machine and there is no Personal.xls(b) files on it at
all, I have uninstalled and re-installed Excel, but the problem is still
there...

Any idea's ??

Reply to this Message

SteveM - 23 Jan 2008 09:10 GMT

> I am using Excel 2007, and have previously written, and used. several
> macro's on this machine. Recently, however, the 'Visual Basic', 'Record
[quoted text clipped - 6 lines]
>
> Any idea's ??

I lost my Personal Workbook (Excel 2003). Ron De Bruin was kind
enough to send me the solution. He also included the fix for 2007.
Thread below:

SteveM

For Excel 2007 users

Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

- Hide quoted text -
- Show quoted text -
"SteveM" <sbm...@vzavenue.net> wrote in message news:
6a5369eb-6606-4e5b-a470-0da9443a3426@w28g2000hsf.googlegroups.com...

>I posted the question below and received the solution from Ron de
> Bruin. This is an FYI in case anybody else experiences the same
> problem. I did not know the Disabled log was available and also found
> a couple of Add-In DLL's that I had "lost." So great piece of info.

> SteveM

> Q: I lost My Personal Macro Workbook. It is not open for Macro
> recording.

> Does anyone know where it may be? How to get it back?

> A: On the Help menu click on About Microsoft Excel

> The see if it is listed in Disabled items

> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

Reply to this Message

Bob Phillips - 23 Jan 2008 09:14 GMT

VBA programmability is an option when installing Office 2007, it is not
selected by default. Try re-running Setup to see if it was installed

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I am using Excel 2007, and have previously written, and used. several
>macro's on this machine. Recently, however, the 'Visual Basic', 'Record
[quoted text clipped - 6 lines]
>
> Any idea's ??

Reply to this Message