Width of dialog box etc

[azizrasul]

If I have a list of workbook names in a worksheet with their full pathnames and 2 additional columns with the headings 'Main Password' and 'Write Access Password'. By iterating through the workbooks, I want to establish that when using the Workbooks.Open and either the 'Main Password' and\or 'Write Access Password' dialog boxes open I want to find the length of the Password dialog boxes which will tell me whether the 'Main Password' or 'Write Access Password' dialog box is open as the 'Write Access Password' dialog box is wider than the 'Main Password'.

Alternatively if the code tells me whether there is a 'Read Only' button on the dialog box that is open then I can tell which dialog box is open.

 

[azizrasul]

If I have a list of workbook names in a worksheet with their full pathnames and 2 additional columns with the headings 'Main Password' and 'Write Access Password'. By iterating through the workbooks, I want to establish that when using the Workbooks.Open and either the 'Main Password' and\or 'Write Access Password' dialog boxes open I want to find the length of the Password dialog boxes which will tell me whether the 'Main Password' or 'Write Access Password' dialog box is open as the 'Write Access Password' dialog box is wider than the 'Main Password'.

Alternatively if the code tells me whether there is a 'Read Only' button on the dialog box that is open then I can tell which dialog box is open.

Sorry I realise that the widths are the same. So the presence of a Read Only button will do what I want.