View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_687_] Simon Lloyd[_687_] is offline
external usenet poster
 
Posts: 1
Default Macro button not appearing when workbook opened?


Hi and thanks for replying,

The code doesnt break normally, when the workbook opens it goes throug
the auto open but then stops with a Runtime 5 fault the only butto
available on the pop up box to click is the End button, the code i
stopping at the last button in my Auto Ope
CommandBars("matrix").Controls("Area Leaders").OnAction ="ALbutt"


if i open the workbook on a computer that has never opened the workboo
before the (i.e before the extra button was added) then all the button
i created appear, but if i open the workbook on a computer that ha
opened it it comes up with the runtime error and does not create th
button but all other buttons are there as normal and operate fine.

Its Driving me mad because i cant get round it and i keep getting phon
callssaying the program isnt working properly so any guidance or hel
you can give will be greatly appreciated.

Regards,

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=50143