maybe you are in design mode when you open the workbook.

Try getting them to a point where they work and save your workbook.

--
Regards,
Tom Ogilvy

"vinayd " wrote in message
...
Hi All,

To start with I've no knowledge of VBA. I created a load of ListBox
Controls and commandbuttons to control the ListBox's on a worksheet.
I've got some code on each of the commandbuttons to return the
selections from the ListBox. I copied this code from the web and it
works fine.

Now, my problem is that when I save the sheet and re-open it, I cannot
access any of the controls on the worksheet (ListBox or
CommandButtons). I need to go into Design View or VB Code at least once
before they all become active.
I've now been struggling with this for a while, without much success.
What am I doing wrong? Help!!!!


---
Message posted from http://www.ExcelForum.com/