| 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 |
| 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 | |||
![aca[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
