Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a work book as values and format only
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a work book as values and format only
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a work book as values and format only
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a work book as values and format only
No, you can place it in a regular module. It is setup to look through every
ws on it's own. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import only certain cell values into a new work book | Excel Discussion (Misc queries) | |||
Hide the zero values in a work book | Excel Worksheet Functions | |||
loss of fidelity error when saving excel work book | Excel Discussion (Misc queries) | |||
loss of fidelity error when saving excel work book | Excel Worksheet Functions | |||
my excel work book is NOT read onlyt says it is when saving to CD | Excel Discussion (Misc queries) |