Replies

20. General

Solution hidden by HansV (see my next reply)

I do not know how to hide the answer….sorry
592
150
6
619
305
312
466
242
395
774

‘Learning is a treasure that will follow it’s owner everywhere’ (chinese?)

After the user fills in the last field they should then hit ‘Tab’ and be resting on the ‘Submit’ button. That would be perfect, but does not have to happen that way.

Doug

Steve,
That worked great! a little fiddling with the rest of my macro and all is almost running smoothly. Just one more tiny issue. This sheet is setup as protected so that users can tab from one entry field to another, but I want to change the order of the tabbed fields. Any thoughts?

Doug

Right, now that is working but I cannot copy sheet1 to the new sheet because the name is a variable. I put in:

Sheets(“D3”).Select

D3 is the cell that I grabbed to name the new sheet. Once I select that sheet I want to paste all the information from Sheet1. Here is the total of my script so far:

Sheets(“Grading”).Select
Sheets.Add.Name = Range(“D3”)
Sheets(“Grading”).Select
Cells.Select
Selection.Copy
Sheets(“D3”).Select
ActiveSheet.Paste

Thanks Hans, that worked. At first I left it on the A1 cell and I got a runtime error, then when I realized that there was nothing in that cell (oops) and changed it to the one it should be, it became B E A utiful!

Thanks again

I like this, but I need to have it go to a network location. i.e.

ActiveWorkbook.SaveAs Filename:= _
“monorailc$<>”, FileFormat:=xlNormal, _

so I do I place the range at this location?

In case anyone out there is watching this post. I just got Outlook 2003 and this issue is now solved. If you adjust the window, and then cancel, Outlook remembers the window size. Also, by default the window was larger.

In case anyone out there is watching this post. I just got Outlook 2003 and this issue is now solved. If you adjust the window, and then cancel, Outlook remembers the window size. Also, by default the window was larger.

I am sorry, I was not clear. This is a form that they are going to fill out on the web. It has radial buttons that the user will select and they want to print the form after they have selected what they want. Thanks

I am sorry, I was not clear. This is a form that they are going to fill out on the web. It has radial buttons that the user will select and they want to print the form after they have selected what they want. Thanks

Changing the window size and then cancelling did not work. Since I first posted (earlier today) I was given a new laptop. The old one had Windows 2000 and the new one is XP, but the problem remains.

Changing the window size and then cancelling did not work. Since I first posted (earlier today) I was given a new laptop. The old one had Windows 2000 and the new one is XP, but the problem remains.

This works, but I am looking for a permanent solution. One that does not add extra work.

I recently received an e-mail from one of the many e-mail mags that I get that had another, less painfull way to do this. Unfortunately I deleted that e-mail. If anyone has another way I would be thrilled to here it.