Basically I'm running out of ideas,

I have a workbook with a few sheets in it. The last sheet is a template
to be sent to clients (just a quote slip). If the sheet is copied into
word, it spaces itself out over about three pages wide and its not
worth the bother going through resizing everything.

If I paste the cells into a new sheet, excel cells don't resize to
match what they were on the other sheet, so its exactly the same
problem.

So I've come up with a macro that goes through and deletes all of the
sheets and values that we don't want the client to see, but then of
course we get troubles with sending the excel quote to the client if
they have any virus scanner or protection, along with it causing
troubles with people who have the higher security level turned on in
excel when they receive the file.

Any suggestions?

Cheers,

You should write a macro to copy data across to a new sheet. However, when
pasting, you should paste special, Values, Column widths, and Formats. This
way, you retain the formats and column widths in your original document,
without revealing your calculations, while there is no macro in the quote
slip.

" wrote:

Basically I'm running out of ideas,

I have a workbook with a few sheets in it. The last sheet is a template
to be sent to clients (just a quote slip). If the sheet is copied into
word, it spaces itself out over about three pages wide and its not
worth the bother going through resizing everything.

If I paste the cells into a new sheet, excel cells don't resize to
match what they were on the other sheet, so its exactly the same
problem.

So I've come up with a macro that goes through and deletes all of the
sheets and values that we don't want the client to see, but then of
course we get troubles with sending the excel quote to the client if
they have any virus scanner or protection, along with it causing
troubles with people who have the higher security level turned on in
excel when they receive the file.

Any suggestions?

Cheers,

Place the macro in your Personal.xls or an add-in then you can run it on any
active workbook.

The macro will not go with the workbook.


Gord Dibben MS Excel MVP

On 23 Oct 2006 20:11:37 -0700, wrote:

Basically I'm running out of ideas,

I have a workbook with a few sheets in it. The last sheet is a template
to be sent to clients (just a quote slip). If the sheet is copied into
word, it spaces itself out over about three pages wide and its not
worth the bother going through resizing everything.

If I paste the cells into a new sheet, excel cells don't resize to
match what they were on the other sheet, so its exactly the same
problem.

So I've come up with a macro that goes through and deletes all of the
sheets and values that we don't want the client to see, but then of
course we get troubles with sending the excel quote to the client if
they have any virus scanner or protection, along with it causing
troubles with people who have the higher security level turned on in
excel when they receive the file.

Any suggestions?

Cheers,