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.
|
Nou pe simpatie:
Profil Popa Bianca
 | Femeie
25 ani
Valcea
cauta Barbat
25 - 63 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| pus acum 3 luni#1 |
TRaPModerator
Postari: 960
|
|
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
|
|
| |
|
