This can be done using VBA.
However, please post your questions in Mac Newsgroups, there are many example that might helpful
Thank you and have a great day.
Sincerely,Ravi AnguluriInnovate On Office Advisory Support Engineer
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?