Clif McIrvin expressed precisely :
"GS" wrote in message
...


I'm curious as to why you'd invoke the dialogs to move/copy when using the
Move/Copy methods accept optional Before/After parameters to specify
destination (within same wkb or other open wkb). If these parameters are
omitted then a new wkb is created with just the moved/copied sheet[s].



The macro is for my use, not for distribution. There are several possible
destination workbooks, and it seemed easier to use the built-in dialog than
to devise code to determine the destination workbook.

Are you running with the sheet tab menu ("Ply") disabled or the no
sheet tabs option set?


I guess I could use the file picker dialog .. then I wouldn't have to
remember to open the destination workbook before launching the macro <g.

Hmm.., sounds like a sheet utilities feature I made for a client
quotation app where users could move/copy selected sheets to other wkbs
that were open, OR click a browse button to open the target wkb if it
wasn't already open. This utility listed all sheets in the active
workbook and displayed info about each (wksName, customer, date, days
aging, date expires, visible...), could hide/unhide sheets (sets a flag
next to hidden ones), rename, delete, email (as attachment), move,
copy, and activate (..where if hidden this was toggled to visible).

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc