View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ole_ ole_ is offline
external usenet poster
 
Posts: 30
Default Copy 1-4 sheets to a new workbook

Hi,

I have a problem finding out how to copy 4 sheets (mymaster.xls) to another
workbook (newWB.xls), the 4
sheets should have the rowheights and formats also copied to the new
workbook,
another problem is that the master.xls have alot of commandbuttons and other
code that i dont want in the newWB.

The area that i want copied in every worksheet is A1-S34 in that area there
is now commandbuttons.

I really hope that there is someone who can help me.

thanks,
Ole