| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls macros will not work in any other sheet
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Personal.xls macros will not work in any other sheet
maybe this thread will help?
http://groups.google.com/group/micro...ce490c07bcb463 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 On Oct 21, 3:11*pm, Kevin wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Personal.xls macros will not work in any other sheet | Excel Programming | |||
| Personal.xls macros only work in that sheet | Excel Programming | |||
| Stop the "Personal" sheet from popping up every time I open a work | Excel Discussion (Misc queries) | |||
| Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
| Turning Off Personal Macros sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
