Here are three things to check, before you try to run the code in your file: or elsewhere in the code.
If you run the code without modifying the reference, you might see an error message: Run-time error '9': Subscript out of range To see where the problem is, click the Debug button, and a line of code will be highlighted in yellow.
Also, you should use different passwords for each account.When you open a workbook that contains macros, you might see a security warning, at the top of the worksheet, above the Formula Bar.If you copy VBA code into your Excel file, you might need to make changes to the object names, or other settings, so that the code works correctly in your file.If you are using macros for the first time on your current computer, you might also need to adjust the macro security settings.Follow the instructions below, to make these changes. So you only have to remember one single master password or select the key file to unlock the whole database. Yes, Kee Pass is really free, and more than that: it is open source (OSI certified). You need a password for the Windows network logon, your e-mail account, your website's FTP password, online passwords (like website member account), etc. You can put all your passwords in one database, which is locked with one master key or a key file.Product datasheet Upgrade Price Guarantee Compatible with Windows 10, 8.1, 8, 7, Vista and XP, 32 Bit / 64 Bit Editions New language versions: Chinese - Lithuanian - Japanese - Polski - Romanian - Spanish - Czech Update Star is compatible with Windows platforms.Update Star has been tested to meet all of the technical requirements to be compatible with Windows 10, 8.1, Windows 8, Windows 7, Windows Vista, Windows Server 2003, 2008, and Windows XP, 32 bit and 64 bit editions.Tips for copying VBA code to a workbook, and checking the code, to ensure that it runs without errors.NOTE: If you're using an older version of Excel, click here for the Excel 2003 instructions for copying code to a workbook.