gcam032
11-25-2010, 10:11 AM
Hi everyone,
There have been related questions on the web but nothing has really helped me unfortunately, probably because I am a complete beginner to VBA.
I was hoping to get some help on this one from someone who can work step by step.
Here's my dilemma. I have a workbook in excel 2007 full of data and sheets that all update dynamically. The person who I share this information with has excel 2003 and so some of the ways I have created the dynamic components are not compatible (especially some advanced conditional formatting).
So what I would like to do is to have a button in my 2007 workbook that runs a macro that does the following:
1. Creates a new workbook
2. Copies some specific worksheets from my 2007 workbook to the new one
- I need it to copy ONLY the values and formats and any logos that are in the sheets.
Can anyone help me get started?
Thanks in advance!!
Gareth
There have been related questions on the web but nothing has really helped me unfortunately, probably because I am a complete beginner to VBA.
I was hoping to get some help on this one from someone who can work step by step.
Here's my dilemma. I have a workbook in excel 2007 full of data and sheets that all update dynamically. The person who I share this information with has excel 2003 and so some of the ways I have created the dynamic components are not compatible (especially some advanced conditional formatting).
So what I would like to do is to have a button in my 2007 workbook that runs a macro that does the following:
1. Creates a new workbook
2. Copies some specific worksheets from my 2007 workbook to the new one
- I need it to copy ONLY the values and formats and any logos that are in the sheets.
Can anyone help me get started?
Thanks in advance!!
Gareth