Search results for query: *

Everyone, As a followup I did do further testing. First, the file is saved as an .xls as some people are using Excel 2003 and others are using Excel 2007. I had someone using 2003, open it, make changes and then close it and it did not prompt them for the VBA password. Using the same file I...

I have been working on VBA code for an Excel spreadsheet. During this coding effort I password protected the VBA code. Since I have password protected the VBA code I get prompted to enter the password for it several times when I exit the spreadsheet. If I do nothing in the spreadsheet and just...

Thanks Skip for the quick reply. Sorry that this is not explained completely but here are more details. Hopefully this helps. The column will have a combobox (ActiveX control) on each row for let's say 100 rows. They would contain the same 4 items for each combobox. The user is to select which...

I am new to using the combobox. All of the comboboxes are in the same column and each have the same four items to select. I am not using a Userform. I want to use VBA to populate the multiple comboboxes. I do not want to specify each combobox individually as follows ComboBox1.AddItem "Item 1"...