Excel - Personal.xls macros will not work in any other sheet
Asked By Kevi
21-Oct-08 03:11 PM
Hi
I upgraded from Office 97 to Office 2007. I copied over my previous
personal.xls file to the XLSTART drive, replacing existing one.
The macros only work on my Personal.xls workbook and not any other ie i get
a message - "Cannot run macro. The macro may not be avaialbe in
this workbook or all macros may be disabled". The macros are not disabled
There must be some setting I can change so they can be used by all workbooks
Thanks
--
Kevin
--
Kevin
Office 2007
(1)
Office
(1)
Workbook
(1)
Macros
(1)
Cdf4d46e03fae325
(1)
Avaialbe
(1)
XLSTART
(1)
Oks
(1)
Susan replied...
maybe this thread will help?
http://groups.google.com/group/microsoft.public.excel.programming/browse_th=
read/thread/cdf4d46e03fae325/2fce490c07bcb463?hl=3Den&lnk=3Dgst&q=3Dpersona=
l.xls+2007#2fce490c07bcb463
try searching the newsgroup for personal.xls & 2007. i'm sorry i
don't have the answer for you but maybe can help
anyway................
susan
i get
oks
Office 2007 Compatibility Pack issue? Excel Setup: - Managed code UDF, isolated via COM shim - Office 2003 with Office 2007 Compatibility Pack installed - Workbook created in Office 2007, uses functions from the UDF assembly If I save the workbook to .xslx format, close
Running Virus Scan" . . . . On Opening Excel Workbook Excel I am running Microsoft Excel 2007 (Office 2007 Business) with XP Pro When I open an Excel 2007 workbook. . . . the bottom left indicates. . . . . . . . . This results in the Workbook taking a long time to open. I located this KB Bulletin http: / / support.microsoft.com kb / 919047 This bulletin refers to Word 2007 Method 1 Suggests I remove the program that installed the addin. . . . .that I assume would
Copy formulas in Office 2007 Excel Hello. A customer can't use "Copy Special" in Office 2007. He has upgradede Office 2007 from 2003. When he copy cells to another workbook, the formulas aren't copied. And when he tries the "Copy Special" a windows comes on several PC's. Not on his. Because of the upgrade? - - Regards, Steffen Excel Discussions Office 2007 (1) Workbook (1) Steffen (1) Sørdal (1) Upgradede (1) Windows (1) Nubmer (1) My
upgrading to office 2007 Excel After installing office 2007, some of my excel office 2003 spreadsheets have lost their formats. Can someone help? Excel Worksheet Discussions Office (1) Excel (1) SaveAs (1) Spreadsheets (1) What do you mean by loosing formats. . .You have an option in 2007 to save as 'Excel 97-2003 Workbook' under Office Button> SaveAs If this post helps click Yes - -- -- -- -- -- -- -- Jacob Skaria *Upgrade* to office
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) Excel Recently we've run into an odd issue trying to get the analysis machine but this one machine, it functions normally. That is to say that going through. . . Office Button -> Excel Options Add-Ins -> Select "Excel Add-Ins" -> Hit the Go. . . button to manage and all patches as of today) - Deleting the Analysis ToolPack from C: \ Program Files \ Microsoft Office \ Office12 \ Library and letting Excel reinstall the ToolPack on next launch - Doing an Office repair through Add / Remove programs - Removing Office, restarting, reinstalling office with "Run all from my computer" selected for every option - Changing features via Add / Remove