View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vinayd vinayd is offline
external usenet poster
 
Posts: 1
Default Activating Worksheet Controls - "Excel VBA Problem"

Hi All,

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

Now, my problem is that when I save the sheet and re-open it, I canno
access any of the controls on the worksheet (ListBox o
CommandButtons). I need to go into Design View or VB Code at least onc
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