If you have two workbooks open in two different instances of excel, then you'll
see this "funny" paste special dialog.

Opening both the workbooks in one instance of excel will get your "normal" paste
special dialog back.

Without seeing the code that you used, I wouldn't guess at the second question.

And for the third question, you can close the workbook like:

someworkbook.close savechanges:=false 'or true

to avoid any prompt.

RHall wrote:

When using "Paste Special" sometimes I get the full selection menu and
sometimes I only get a choice for unicode or text. What determines which one
I get?
Also, when I "paste special" requesting "Values" in a recorded macro the
receiving worksheet moves columns to the right of my paste to the left. I
pasted in columns "A" & "B" and it moved a formula in column "H" to "F".
What's going on?
Also, when recording the macro it does not capture the "NO" to saving the
file when closing it. I don't want my user to have the option to save it
since the macro used a filter selection.
Thanks for any help. RHall
--
none

--

Dave Peterson