Can I save only one sheet of a workbook and leave the rest unchanged ?

  • Thread starter Thread starter Marvin Hlavac
  • Start date Start date
M

Marvin Hlavac

Hi,

This may not even be possible but what I think I need is a macro that would
save only one worksheet and let the rest of the worksheets be unsaved. I
have a workbook of about 20 worksheets and only one needs to be occasionally
saved. I never want changes in the other sheets to be saved. Is this
possible?
 
Could you protect the 19 sheets so that the user can't make changes to them?

Could you separate the workbook into two workbooks--one with 19 worksheets
(marked readonly) and the other with the single worksheet?

But if there are formulas on that single sheet that refer to some of the other
19 worksheets, how would you handle them--convert to values so not saving the
changes on the 19 worksheets wouldn't have the single sheet revert to the old
values????

If you just save that single worksheet as values, you could convert it to
values, copy it to a new workbook and save from there.

(Or convert it to values and delete the 19 other worksheets.)

=========
And if you had to keep the worksheets all in one workbook--but still no formulas
on that single sheet that refered to the other 19, you could keep a "mirrored
version" of each of the 19 worksheets (and those would be hidden from the user).

Then you could have the macro just copy each "mirrored version" to the visible
worksheets.

So I guess it really depends on what you're doing and how your workbook is set
up.
 
And if you had to keep the worksheets all in one workbook--but still no formulas
on that single sheet that refered to the other 19, you could keep a "mirrored
version" of each of the 19 worksheets (and those would be hidden from the user).

Then you could have the macro just copy each "mirrored version" to the visible

Dave Peterson
(e-mail address removed)
Click to expand...



Thanks Dave, that will most likely be the way I will do it.
 
Back
Top