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
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] How to Close an Add-in Without Having to Close Excel Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
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
   
Pagini: 1  

Mergi la