Can non-Muslims use the visit visa to go to Makkah and Madinah for Tourism?

Only Muslims can access the city of Makkah, while non-Muslims holding a visa can access the city of Madinah, except the prophet’s haram in Medina