Remove samrad datepicker

miami2k

Board Regular
Joined
Nov 1, 2017
Messages
55
Dear All,

I was trying to add a date picker on my userform and I installed Sam Radakovits Date Picker Excel Date Picker — Sam Radakovitz.
In the end I've never used it because I don't like it and also because I don't want to install it on all the PC of the users.
My project worked on any machine with any version of Excel, but lately, when I access the file from other PCs on which the app is not installed it says that a link is broken and even if I interrupt it comes up again when I close and reopen the file.
I have two questions:
- the first one is how to remove the app from my PC. I have these! :cautious::)
1596783634830.png


1596783727776.png


- the second is how to find the link in my project (this is the file MrExcel Sample.xlsm)


If you have any suggestion for any Date Picker to insert in an userform it would be much appreciated. Like the one that used to work in the old versions of Excel.


Thank you very much.


miami2k
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,759
Office Version
  1. 365
Platform
  1. Windows
Not sure about the existing date picker you're using, but with regard to your last question...

The old MS calendar control is no longer supported by MS. If you try installing an old version (even after registering the control in the Registry) it'll probably only give you issues - especially if you're running your WB on other machines.

Why aren't you using the DTPicker supplied by MS? AFAIK, it still works with all versions, and is also available with all installations. If it's not visible on your Toolbox, then right-click, and select "Additional control" "Microsoft Date & Time Picker Control."
 

miami2k

Board Regular
Joined
Nov 1, 2017
Messages
55
Not sure about the existing date picker you're using, but with regard to your last question...

The old MS calendar control is no longer supported by MS. If you try installing an old version (even after registering the control in the Registry) it'll probably only give you issues - especially if you're running your WB on other machines.

Why aren't you using the DTPicker supplied by MS? AFAIK, it still works with all versions, and is also available with all installations. If it's not visible on your Toolbox, then right-click, and select "Additional control" "Microsoft Date & Time Picker Control."
I will try that, I've not been able to find it before. Thanks
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,759
Office Version
  1. 365
Platform
  1. Windows
Pleasure. Please report back as to whether you fond it, or not; this could well help others with the same issue. Ta.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,428
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile

ADVERTISEMENT

Why aren't you using the DTPicker supplied by MS? AFAIK, it still works with all versions
AFAIK, it is still not Office 64bit compatible.
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,759
Office Version
  1. 365
Platform
  1. Windows
@MARK858
Thanks for pitching in there.
I wasn't aware of that. It'll all boil down to whether the OP has 32 or 64 bit (on all of the other users' machines). If it's a large company, it could well be 64, I guess.
 

miami2k

Board Regular
Joined
Nov 1, 2017
Messages
55
Yes we all have 64bit, this is why I tried with addons designed by other users but I didn't find any I liked.
Going back to my main topic, any idea how to break the link and remove the date picker?

Thank you!!!
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,428
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Removing it should be simple.
An Excel Addin is just an Excel file with an Xlam extension.

First disable it in Excel by in your Excel file click the File Tab - Options - Add-Ins - Make sure the Manage Addins is set to Excel Add-ins - click Go - find the Addin in the list and clear the checkbox - click OK.

Now find it's file location (normally something like C:\Users\YOURUSERNAME\AppData\Roaming\Microsoft\Addins) and do a straightforward right-click and delete the file.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,021
Messages
5,545,542
Members
410,690
Latest member
navneetr
Top