Thread
:
If page does not exist
View Single Post
#
6
Posted to microsoft.public.excel.programming
K Dales[_2_]
external usenet poster
Posts: 1,163
If page does not exist
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?
Reply With Quote
K Dales[_2_]
View Public Profile
Find all posts by K Dales[_2_]