Checkbox Private

F

Frank Van Eygen

I have a macro in Excel that generates a calendar appointment in Outlook that
works fine except that I don't know how to set the Private checkbox in
Outlook.
Can somebody help please?
 
S

Sue Mosher [MVP]

The object browser (F2 in VBA) is your friend. Take a look at the
AppointmentItem.Sensitivity property.
 
F

Frank Van Eygen

Tahnk you Sue,
This did the trick:
Set olApt = olApp.CreateItem(olAppointmentItem)
olApt.Sensitivity = olPrivate
 
Top