Thread: Runtime Error 1004:Method 'Range' of object'_Worksheet' Failed
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default Runtime Error 1004:Method 'Range' of object'_Worksheet' Failed
hi,

if the button is on a Excel spreadsheet

ActiveSheet.CommandButton1.TakeFocusOnClick = False


--
isabelle
Reply With QuoteReply With Quote