Always Show Message After Uninstall Excel Add-Ins

Susanto3311
3StarLounger
Posts: 240
Joined: 17 Feb 2022, 05:16

Always Show Message After Uninstall Excel Add-Ins

Post by Susanto3311 »

hi all..

i have problem about excel add-ins. i have uninstall that app but uncheck excel add-ins & remove that app
but when i open new workbook always show message "sorry, we cound't find D"\......"

how to clean that.? never show again that message

thank in advance

susant
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78568
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Always Show Message After Uninstall Excel Add-Ins

Post by HansV »

Best wishes,
Hans

snb
4StarLounger
Posts: 586
Joined: 14 Nov 2012, 16:06

Re: Always Show Message After Uninstall Excel Add-Ins

Post by snb »

Try:

Code: Select all

Sub M_snb()
   On Error Resume Next

   For Each it In AddIns
     If it.Installed = True And Dir(it.FullName) = "" Then it.Installed = False
     If Err.Number <> 0 Then it.Installed = False
     Err.Clear
   Next
End Sub

User avatar
DocAElstein
5StarLounger
Posts: 604
Joined: 18 Jan 2022, 15:59
Location: Re-routing rivers, in Hof, Beautiful Bavaria

Re: Always Show Message After Uninstall Excel Add-Ins

Post by DocAElstein »

Hello

I had this problem a lot. None of the published solutions I ever tried worked for me. In the meantime I gave up and just got in the habit of liberally hitting the Enter or Esc key when I open Excel

However, I did recently see this, and the author claims all the usual stuff did not work for him but that this solution did
https://newtonexcelbach.com/2022/06/05/ ... g-add-ins/
( https://stackoverflow.com/questions/194 ... 07#1946607 )

( I have not tried it myself, because in the meantime I learnt a nice drum rhythm to go with hitting the Enter and Esc keys as I open my Excel, which I quite like to practice )

Alan
I seriously don’t ever try to annoy. Maybe I am just the kid that missed being told about the King’s new magic suit, :(

snb
4StarLounger
Posts: 586
Joined: 14 Nov 2012, 16:06

Re: Always Show Message After Uninstall Excel Add-Ins

Post by snb »

Hi @doc

Why don't you test my suggestion ?

User avatar
DocAElstein
5StarLounger
Posts: 604
Joined: 18 Jan 2022, 15:59
Location: Re-routing rivers, in Hof, Beautiful Bavaria

Re: Always Show Message After Uninstall Excel Add-Ins

Post by DocAElstein »

I probably will try that or the one I posted.

I have some long term plans for various reasons for this winter to film myself trying to fix some broken things. I am storing up ideas, but don’t want to fix too many things yet, in case I cant easily break them again, and then run out of things to film myself repairing…
I seriously don’t ever try to annoy. Maybe I am just the kid that missed being told about the King’s new magic suit, :(

snb
4StarLounger
Posts: 586
Joined: 14 Nov 2012, 16:06

Re: Always Show Message After Uninstall Excel Add-Ins

Post by snb »

fair enough.....