Of course I understand how users could save a worksheet separately. However,
it's not common practice and I wanted to make sure that there was no
confusion between workbooks and worksheets in the OP's mind.

--

Vasant


"K Dales" wrote in message
...
In addition to Aaron's answer, the user could right-click on the worksheet
tab, select "Move or Copy..." and then copy to a new workbook.

"Vasant Nanavati" wrote:

I think there is some confusion here. How can a user save only a single
sheet?

--

Vasant

"Aaron Howe" <Aaron wrote in message
...
I have a small piece of code in an Excel sheet which validates whether
a
field has been completed and then allow a print if it has been.
Here's
the
code:

Private Sub CheckPrint_Click()
If Worksheets("Checks").Range("D33").Value = "No" Then
ActiveSheet.PrintOut
Else
MsgBox "There is an error on form - check all required fields (marked
in
red) have been completed properly and try again"
End If
End Sub

- Problem is, users are saving a copy of the main sheet (SOS) and then
printing - hence they get an error as the macro cannot complete if
they
only
save the SOS worksheet (the Checks sheet is hidden). Is there a way
of
telling Excel that if the page does not exist, carry on to complete
the
task
(printing) anyway?