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 ??

On Jan 23, 2:50 am, "Redbreva" wrote:
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 ??

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 buttonExcel 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" wrote in message news:
...
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

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

--
---
HTH

Bob


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



"Redbreva" wrote in message
...
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 ??