Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: Lolo
 | Femeie 24 ani Galati cauta Barbat 25 - 52 ani |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 911
|
|
I was in VBA, where I updated an add-in in order to send it to someone. The add-in was not loaded (enabled), just open in VBA for editing. When trying to send it, I got error that it is currently in use.
To close it I used the following method:
1. Opened VBA
2. Clicked in the Immediate window (regardless which VBAProject is selected)
3. Typed the following command and pressed enter:
| Workbooks("My current add-in.xlam").Close SaveChanges:=False |
Note: If add-in is loaded/enabled, you can unload either via Options, or using the following command in the Immediate window in VBA:
| AddIns("My current add-in.xlam").Installed = False |
Source: ChatGPT
|
|
| pus acum 11 zile |
|