Personal Workbook - Macro's

[martinblake02]

Hi,

I am using Excel 2007 at work and my Personal workbook has disappeared.

I have checked the XLSTART folder and the file is there, I can manually open it and it works.
It also works if I open a new/blank excel document.

However if I open a file I have created/saved, then the Personal workbook does not also open.

help please

Thanks

 

[Andrew Poulsom]

Maybe it's disabled. In Excel Options Add-ins choose Disabled items in the Manage dropdown and click Go.

 

[martinblake02]

Maybe it's disabled. In Excel Options Add-ins choose Disabled items in the Manage dropdown and click Go.

Hi,

nothing is disabled.

thanks though

 

[Andrew Poulsom]

How are you opening the file you have already saved? If you open it from Excel your Personal Macro Workbook should already be open.

 

[martinblake02]

I am opening it from the desktop

 

[Andrew Poulsom]

Using File Open in Excel or without Excel open?