Load a Calendar Library Object

chrisjgwhite

New Member
Joined
May 26, 2005
Messages
20
I am trying to use the calendar object on a form in VBA and followed the instructions on other threads for how to load this (ie in references, etc) and I have it all working. The spreadsheet needs to be used by a wide variety of people and I wanted to know if there is a way of automatically loading this reference on each machine as part of the program when it begins to run.

Basically instead of going to each machine to manually load the reference for the calendar I want it to be done as part of the program. any help would be much appreciated.

Thanks
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Set it up in an add in and push it down to everyone's add-in folder. (on XP-Pro it will be C:\Documents and Settings\All Users\Application Data\Microsoft\AddIns)

You can make it an add in by simply making one workbook with all the functions you want save it, and rename it with a .xla extension. If you want to really dumb it down, after you have mass distributed the add-in send everyone a work book with this code in a module.

Function Auto_Open()
Dim AddInName As String
On Error Resume Next
AddInName = "chrisjgwhite"
AddIns(AddInName).Installed = True
If AddIns(AddInName).Installed = True Then
MSBGBox = AddInName & " Installed Correctly."
Application.DisplayAlerts = False
ThisWorkbook.Close
End If
End Function
 
Upvote 0

Forum statistics

Threads
1,223,192
Messages
6,170,646
Members
452,344
Latest member
LarryRSch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top