Desert Piranha
02-03-2007, 02:13 AM
Hi all,
I have xl2000, and i left it on, and installed xl2007.
With excel 2000 my Personal.xls is in:
C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\XLSTART
I have Macros and custom Toolbars in it. (all work fine)
Now in 2007 all the custom Toolbars show up in "Add-Ins<Menu Commands".
This is fine and everything works.
I have rcorded Macros in 2007.
I do not have an Personal.xlsb on hard drive, as 2007 is using the
Personal.xls from xl2000.
Is this any kind of a problem, that should be fixd??
Should i make another Personal with the xlsb extention??
This is from help. I can edit it in VBE but whats the Unhide Command, Its not "Window> Unhide" anymore??
Tip: You cannot edit your Personal Macro Workbook file (Personal.xlsb) because it is a hidden workbook that is always open. You must first unhide it by using the Unhide command. You can also open it in the Visual Basic Editor by pressing ALT+F11.
I have xl2000, and i left it on, and installed xl2007.
With excel 2000 my Personal.xls is in:
C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\XLSTART
I have Macros and custom Toolbars in it. (all work fine)
Now in 2007 all the custom Toolbars show up in "Add-Ins<Menu Commands".
This is fine and everything works.
I have rcorded Macros in 2007.
I do not have an Personal.xlsb on hard drive, as 2007 is using the
Personal.xls from xl2000.
Is this any kind of a problem, that should be fixd??
Should i make another Personal with the xlsb extention??
This is from help. I can edit it in VBE but whats the Unhide Command, Its not "Window> Unhide" anymore??
Tip: You cannot edit your Personal Macro Workbook file (Personal.xlsb) because it is a hidden workbook that is always open. You must first unhide it by using the Unhide command. You can also open it in the Visual Basic Editor by pressing ALT+F11.