View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Gittins John Gittins is offline
external usenet poster
 
Posts: 13
Default Macro assignment to button gets reassigned

can you show the code originally assigned to the button so we can check it?

"Rob" wrote in message
...
Very bizzare behaviour. I have a button with a macro (VBA
Procedure I had written) assigned to it. For some unknown
reason, the assinged macro has changed and now references
a Named Reference! And in some cells I use the vlookup
function with a Named Reference, it replaced that Named
Reference with a VBA Procedure I had written.

Any idea what is going on here? I have Excel 2000,
9.0.2720.

Thanks!

Rob