| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Improve 'Windows(workbook.xls).Activate" statement
You try creating an excel addin (xla) which can be incorportated as part of an excel instance. Then you can run the macro using the reference 'activeworkbook '. it's a little more complicated but there's plenty of information about creating them on excelforum.com -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=538047 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Activate "Show all" in a Protected Shared Workbook | Excel Discussion (Misc queries) | |||
| Can I keep "Windows of active workbook check box" checked | Excel Discussion (Misc queries) | |||
| Workbook.Activate / Window.Activate problem | Excel Programming | |||
| Activate "current workbook" | Excel Programming | |||
| Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo | Excel Programming | |||
![MattShoreson[_102_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
