saving a copy without formulas
 

I am trying to save a copy from a template which contains values in place of
formulas. I want user to enter inputs in to template sheet allow the user to
save copy with results of formula alone. The origional formula shall not be
copied to copy saved from my template. Please help.

Thanks

saving a copy without formulas
 

Please check the replies for your previous post.

if you are looking to do that manually; use Ctrl+A to
select and copy. Target sheet Ctrl+A and Right click Paste special|Values.....

If programatically refer the post by Mike H

If this post helps click Yes
---------------
Jacob Skaria


"Ravi Kumar" wrote:

I am trying to save a copy from a template which contains values in place of
formulas. I want user to enter inputs in to template sheet allow the user to
save copy with results of formula alone. The origional formula shall not be
copied to copy saved from my template. Please help.

Thanks

saving a copy without formulas
 

Thank You Jacob Skaria,

But the reply did not give me the required advice. Probably, I could not
pose my question properly. What I need is, when I open a template a read
only workbook opens, On saving a copy of perhaps after filling in the blanks
it should save only value but not formulas to the copy. If I am clear with
my problem Please help out. Thank U.

"Jacob Skaria" wrote:

Please check the replies for your previous post.

if you are looking to do that manually; use Ctrl+A to
select and copy. Target sheet Ctrl+A and Right click Paste special|Values.....

If programatically refer the post by Mike H

If this post helps click Yes
---------------
Jacob Skaria


"Ravi Kumar" wrote:

I am trying to save a copy from a template which contains values in place of
formulas. I want user to enter inputs in to template sheet allow the user to
save copy with results of formula alone. The origional formula shall not be
copied to copy saved from my template. Please help.

Thanks

saving a copy without formulas
 

If you want code to change all formulae to static figures then drop this
in your save code at the beginning (provided you want all sheets to be
processed the same)

Dim Sh As Worksheet
For Each Sh In Sheets
Sh.UsedRange = Sh.UsedRange.Value
Next Sh


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79952