Hi,
I am reading an XLSM file and have some processing to do including writing some data in it. Unfortunately there are some data validation of list type on the cells and I do not write these values in the cell. Don’t ask me why, I receive this file as is and these validation are usefull later in the process. Can you point to the correct way to work around these validations ? perhaps invalidate them for the time of my processing and revalidate them afterwards ? Thanks for your help. Friendly regards. Marco.
