Define array of sheets by inputbox
The application.InputBox will allow selection of ranges, but it won't
support selecting sheets.
You can put up a userform with a listbox (set for multiselect) or separate
checkboxes with the sheets listed and let the user select from there.
--
Regards,
Tom Ogilvy
"Herman" wrote in message
m...
Hello
I'm editing a procedure to copy certain sheets TOGETHER from Workbook
A to Workbook B.
In book A the user will be asked to click his way to book B. I know
how to do that.
But with book B activated an inputbox should prompt for the sheets to
be copied together (selecting while holding the Ctrl key down). I
think this should be done by an array input (type 64) but I can't
figure it out.
Can anyone help me here?
Thank you very much.
Herman
|