Unable to access VBA editor
 

Hi,

I have just re-installed Office 2007, and now when I load Excel, the "Visual
Basic", "Macros" and "Record Macro" icons in the Developer ribbon are grayed
out and 'Alt F11' does nothing except cause a 'ping' noise.

I previously have some Macro's stored in the Personal.xlsb and seem to
remember hiding it.

I can't now find how to get back into this area, and am at a loss on how to
recove this functionallity - anyone any ideas?

Unable to access VBA editor
 

Perhaps finding out where your Personal.xlsb is and renaming it to something
else so that Excel will not load it might help..

Tyro

" wrote in message
...
Hi,

I have just re-installed Office 2007, and now when I load Excel, the
"Visual Basic", "Macros" and "Record Macro" icons in the Developer ribbon
are grayed out and 'Alt F11' does nothing except cause a 'ping' noise.

I previously have some Macro's stored in the Personal.xlsb and seem to
remember hiding it.

I can't now find how to get back into this area, and am at a loss on how
to recove this functionallity - anyone any ideas?

Unable to access VBA editor
 

No file by that name can be found on the system !! There were over 100
'shortcuts' to it in the recent file list, but the actual Personal.xlsb
itself is nowhere to be found

"Tyro" wrote in message
...
Perhaps finding out where your Personal.xlsb is and renaming it to
something else so that Excel will not load it might help..

Tyro

" wrote in message
...
Hi,

I have just re-installed Office 2007, and now when I load Excel, the
"Visual Basic", "Macros" and "Record Macro" icons in the Developer ribbon
are grayed out and 'Alt F11' does nothing except cause a 'ping' noise.

I previously have some Macro's stored in the Personal.xlsb and seem to
remember hiding it.

I can't now find how to get back into this area, and am at a loss on how
to recove this functionallity - anyone any ideas?

Unable to access VBA editor
 

Check to see if it is loaded by unhiding it in Excel. Does your windows
explorer show you hidden files? Did you search for personal.* and not
personal.xslb?

Tyro

" wrote in message
...
No file by that name can be found on the system !! There were over 100
'shortcuts' to it in the recent file list, but the actual Personal.xlsb
itself is nowhere to be found

"Tyro" wrote in message
...
Perhaps finding out where your Personal.xlsb is and renaming it to
something else so that Excel will not load it might help..

Tyro

" wrote in message
...
Hi,

I have just re-installed Office 2007, and now when I load Excel, the
"Visual Basic", "Macros" and "Record Macro" icons in the Developer
ribbon are grayed out and 'Alt F11' does nothing except cause a 'ping'
noise.

I previously have some Macro's stored in the Personal.xlsb and seem to
remember hiding it.

I can't now find how to get back into this area, and am at a loss on how
to recove this functionallity - anyone any ideas?

Unable to access VBA editor
 

unhide is also grayed out in excel
Explorer *does* show hidden/system files
yep, searched for personal.* - nothing found

Mark

"Tyro" wrote in message
...
Check to see if it is loaded by unhiding it in Excel. Does your windows
explorer show you hidden files? Did you search for personal.* and not
personal.xslb?

Tyro

" wrote in message
...
No file by that name can be found on the system !! There were over 100
'shortcuts' to it in the recent file list, but the actual Personal.xlsb
itself is nowhere to be found

"Tyro" wrote in message
...
Perhaps finding out where your Personal.xlsb is and renaming it to
something else so that Excel will not load it might help..

Tyro

" wrote in message
...
Hi,

I have just re-installed Office 2007, and now when I load Excel, the
"Visual Basic", "Macros" and "Record Macro" icons in the Developer
ribbon are grayed out and 'Alt F11' does nothing except cause a 'ping'
noise.

I previously have some Macro's stored in the Personal.xlsb and seem to
remember hiding it.

I can't now find how to get back into this area, and am at a loss on
how to recove this functionallity - anyone any ideas?

Unable to access VBA editor
 

If you open excel in safe mode:

Close excel
windows start button|Run
type:
excel /safe
and hit enter

Can you get to the VBE?

Starting in safe mode stops lots of things from happening--no macros, no
customized toolbars (ribbon??).

Another way to search for files is to use an old DOS command:

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir personal*.xl* /s

The /s says to search subfolders, too.

Make a note of the locations of the found files. I would move them somewhere
else--not just rename them.

" wrote:

Hi,

I have just re-installed Office 2007, and now when I load Excel, the "Visual
Basic", "Macros" and "Record Macro" icons in the Developer ribbon are grayed
out and 'Alt F11' does nothing except cause a 'ping' noise.

I previously have some Macro's stored in the Personal.xlsb and seem to
remember hiding it.

I can't now find how to get back into this area, and am at a loss on how to
recove this functionallity - anyone any ideas?

--

Dave Peterson

Unable to access VBA editor
 

When you reinstalled did you make sure that Visual Basic for Application was
selected under Shared Features?

--
Jim
" wrote in message
...
| Hi,
|
| I have just re-installed Office 2007, and now when I load Excel, the
"Visual
| Basic", "Macros" and "Record Macro" icons in the Developer ribbon are
grayed
| out and 'Alt F11' does nothing except cause a 'ping' noise.
|
| I previously have some Macro's stored in the Personal.xlsb and seem to
| remember hiding it.
|
| I can't now find how to get back into this area, and am at a loss on how
to
| recove this functionallity - anyone any ideas?
|