Archiving single sheets form workbook

[tawnee jamison]

Can I have only one sheet auto archive?

--------------------------------------------------------------------------------

I have a workbook that has multiple pages. Periodically this workbook
main page updates. Subsequently, all the other sheets update. The use
will select certain sheets to print, archive and send to clients. I
there a way to auto archive these sheets only when they are accesse
via a hyperlink?

Below is a sample I have used for workbooks created that only have on
sheet.


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$q$2" Then
ActiveWorkbook.SaveAs FileName:="J:\rate caps completed\"
ActiveSheet.Range("v23")
End If

End Sub

Can anyone help me?

Thanksso much, Tawnee

 

[Dave Peterson]

I'm not quite sure what archive means or what auto-archive means. And how
hyperlinking fits in.

But if you only want to save certain sheets in the workbook, you can copy them
to a new workbook and save that new workbook.

click on the first worksheet tab and ctrl-click on subsequent worksheet tabs.
Edit|move or copy sheet
(and follow the dialog--check that "create a copy" box)

Then save that new workbook.

If you need a macro, you could record one when you did it manually.