View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
pjelliffe[_3_] pjelliffe[_3_] is offline
external usenet poster
 
Posts: 1
Default control toolbox is disabled


Sorry, but they're both greyed out. I went into design mode, with both
the Forms and Controls toolbars open, and they are both disabled.

Instead I selected all the sheets and copied them to a new workbook,
and the controls were enabled again.

What is especially strange in my case was that I had added controls a
while ago. I opened up the workbook recently and they were gone. I
thought maybe I didn't save my changes when I added them. But copying
them to a new sheet made them reappear!


--
pjelliffe
------------------------------------------------------------------------
pjelliffe's Profile: http://www.excelforum.com/member.php...o&userid=34315
View this thread: http://www.excelforum.com/showthread...hreadid=521918