View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
syaronc[_6_] syaronc[_6_] is offline
external usenet poster
 
Posts: 1
Default Multiple sheets selection and copy


Hi All,
I have a very big report with a lot of links and formulas.
The file is very "heavy" and therefore when i send it, i send it a
values only without all links and formulas.Also, the users only ge
some of the sheets and not all of them because not all the seets ar
required for the report.

i would like to create a code(maybe a user form) that will allo
selecting which sheets will be copied by value and format to the fil
that will be sent later on to the users.

Please Help
Yaron

--
syaron
-----------------------------------------------------------------------
syaronc's Profile: http://www.excelforum.com/member.php...fo&userid=1026
View this thread: http://www.excelforum.com/showthread.php?threadid=27204