Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exist or Not. | Excel Discussion (Misc queries) | |||
Am I Looking For Something That Doesn't Exist? | Excel Discussion (Misc queries) | |||
BLANK EXCEL PAGE STILL EXIST AFTER I CLOSE OUT SPREADSHEET? | New Users to Excel | |||
count how often a name exist | Excel Worksheet Functions | |||
Does worksheet exist | Excel Programming |