Checkbox Private

[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?

 

[Sue Mosher [MVP]]

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

 

[Frank Van Eygen]

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