Thread: PERSONAL.XLSB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default PERSONAL.XLSB

I only have English Excel, not sure but look at this key in the registry

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\General\Xlstart

The value I have is XLSTART which is what I'd expect in my English version,
but you should have XLINÍCIO. If not try changing it (but be sure you can
restore the previous setting if necessary).

If that works you will also want to ensure the path is in a Trusted
Location.
Excel Options/Trust Center/Trusted Locations

You can also look in the registry
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\Trusted
Locations\

Ah but if you only have an XLSB that might not be necessary (unusual,
normally XLSM to store macros)

Regards,
Peter T

"Joe" wrote in message
...
Hi

I have the following problem...

I recorded I macro and chose to save in the Personal macro workbook.

After closing and saving the files, a file named PERSONAL.XLSB is found in
the path

C:\Documents and Settings\<username\Dados de
aplicativos\Microsoft\Excel\XLINÍCIO

I'm using the EXCEL 2007 Brazilian Portuguese version.

The problem: opening Excel, the PERSONAL.XLSB file is NOT opened
automatically, as should be.

How can I fix this problem?

Thanks in advance for your anwser.

Joe