Copy method in a click event
Posted by Kevin on August 20, 2001 12:27 PM
I have a command button on a worksheet and when that button
is clicked I want the sheet to copy. I keep getting a
'Copy method of Worksheet Class failed.' The code I am using is
Sheets("Final Report").Copy. I do not get this
error when I have a command button on a form as a custom
dialog box using the same code. I always need this
command button on the worksheet. I do not want a range
copied, I need the entire sheet copied.
Does anyone have any ideas?