RE: Saving a work book as values and format only

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Would I place this macro in every worksheet?

Thanks for your help

Stew

"Luke M" wrote:

This macro should cause all cells values to become static.

Sub BecomeStatic()
For Each ws In ActiveWorkbook.Worksheets
On Error Resume Next
ws.UsedRange.Value = ws.UsedRange.Value
Next ws
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"stew" wrote:

workbook Hi all
I will be finishing a project Soon and I would like to save as Values and
Format only for the whole work book. This would allow me strip out all the
data on the original workbook in readyness to start my New project. Is this
possible?

thanks for Looking
Stew
.

Relevant Pages

  • Re: address
    ... "David Biddulph" wrote: ... "Luke M" wrote: ... "stew" wrote: ... Note that your math operations at the end simplify to ...
    (microsoft.public.excel.misc)
  • Re: address
    ... "Luke M" wrote: ... "stew" wrote: ... Note that your math operations at the end simplify to ...
    (microsoft.public.excel.misc)
  • RE: Saving a work book as values and format only
    ... you can place it in a regular module. ... It is setup to look through every ... "stew" wrote: ... "Luke M" wrote: ...
    (microsoft.public.excel.misc)
  • RE: Saving a work book as values and format only
    ... This macro should cause all cells values to become static. ... Sub BecomeStatic() ... Luke M ... "stew" wrote: ...
    (microsoft.public.excel.misc)
  • RE: address
    ... "stew" wrote: ... Can't seem to make any of thes work. ... "Luke M" wrote: ... Note that your math operations at the end simplify to ...
    (microsoft.public.excel.misc)