Command Button

[jongdg]

This is probably a simple problem. There are certain macro's that
want to assign a command button to. I have no problem if the macr
functions within the sheet that contains the button. But, if the macr
calls for information contained within a different sheet, the macr
fails. The strange part is that these macro run fine if there no
assigned to a command button. But once the same macro code is copie
into the private sub of a command button, it fails

 

[Dave Peterson]

Two guesses.

#1. You're using xl97. Try changing the .takefocusonclick to False.
Or add: Activecell.activate (right near the top of your code)

#2. You didn't qualify your ranges.
If it's an unqualified range in a worksheet module, then it refers to the
sheet that owns the code:

behind sheet1:
worksheets("sheet2").select
range("a1").value = 99

that range("a1") refers to sheet1--not the activesheet.

 

[Rob van Gelder]

Could you please supply the code?