Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the default “macros in all workbooks”
In Excel, when we open several workbooks containing macros, the default option is that the macros of them all are active; which sometimes causes a particular macro to act on the wrong file or workbook. So I have to MANUALLY go to TOOLSMACROS and, in the MACROS IN box below the list of macros, select the option THIS WORKBOOK instead of the default ALL WORKBOOKS. Is there a way of having that default permanently so changed on my Excel, or of having it changed AUTOMATICALLY on opening the workbook? Many thanks for any help or tip. A. C. -- aca ------------------------------------------------------------------------ aca's Profile: http://www.excelforum.com/member.php...o&userid=25933 View this thread: http://www.excelforum.com/showthread...hreadid=566963 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the default “macros in all workbooks”
It seems to me that your code needs to be edited. The macros' names should be unique. The sheets and the workbooks should have unique names. The code should refer to specifiv sheets. You can use ThisWorkbook.Name in code -- raypayett ----------------------------------------------------------------------- raypayette's Profile: http://www.excelforum.com/member.php...fo&userid=2956 View this thread: http://www.excelforum.com/showthread.php?threadid=56696 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the default “macros in all workbooks”
Yes, I see now that my error lies there. Thank you so much, ray ACA -- aca ------------------------------------------------------------------------ aca's Profile: http://www.excelforum.com/member.php...o&userid=25933 View this thread: http://www.excelforum.com/showthread...hreadid=566963 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set default column width for all new workbooks? | Excel Discussion (Misc queries) | |||
Changing the default delimiter | Excel Discussion (Misc queries) | |||
Creating a default for all new workbooks | Excel Discussion (Misc queries) | |||
choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
Changing file default | Excel Worksheet Functions |