Hello,
I have a workbook that uses the Microsoft Date and Time Picker control. However some users do not have this control installed on their systems. (I cannot install it because I do not have admin access to do so.) When those users open the workbook or click on the button to load the user form containing the Date/Time Picker control they get this error:
"Could not load an object because it is not available on this machine."
excel alert.jpg
The workbook can still function fine without this control, it's just an easier way for the users to select the dates. (They can manually enter them instead of using the Date/Time picker if they have to.) Is there any way I can just prevent this alert from appearing? I've tried using application.displayalerts=false in the workbook open event and in the code that shows the userform and it doesn't work. Any help is appreciated!
Bookmarks