My excel contains a comaddin that is implemented by the company I work for, in which when the user saves a file it brings up a dialogue box in which they have to specify the type of document it is (e.g. public, confidential etc...). As I am unable to disable this (see https://stackoverflow.com/questions/33367531/disable-but-not-disconnect-excel-com-addin-with-vba) my alternative thought was whether there was a way to implement a default response to this within the vba (e.g. always select public when this dialogue box appears). Does anyone know whether this is viable and if so how I would go about it?
Thanks.