Good morning all.

I am just not very with it this morning and am having trouble with
save button on an Excel sheet. The button lives on a sheet name
"Report". The code I've been testing (that works like a charm so far
lives in ThisWorkbook (under General). The trouble seems to come whe
I copy the code from ThisWorkbook to the Report , which is where th
btnSave_Click appears when I right click on it to program it. It give
me a run-time error '1004': Select method of Range class failed when
try to run the newly copied code (F5).

The "Save" button was created with the Controls Toolbox, Command Butto
(if it matters) and I am running MSOffice with Windows 2000 (in cas
that makes a difference as well).

What I would like to be able to do is call the working code from wher
it is with the button on the Report page.

I'm sure this will be easy for most of you, and I greatly appreciat
any help offered. :)

Thank you in advance,
Cande

--
Message posted from http://www.ExcelForum.com