show a message if print

[CC]

Hi

I need that when I click for print show a message remember me to do
something else and just iniciate printage if I agree
is it possible ??


many thanks

 

[Jacob Skaria]

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=INDEX(A1:A1000,MODE(IF(A1:A1000<>"",MATCH(A1:A1000,A1:A1000,0))))

 

[Jacob Skaria]

Please ignore my previous post .

For your query

Set the security level to low/medium in (Tools|Macro|Security). From
workbook press Alt+F11 to launch VBE (Visual Basic Editor). From the left
treeview search for the workbook name and click on + to expand it. Within
that you should see the following

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
This Workbook

Double click 'This WorkBook' and paste the below code to the right code pane.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If MsgBox("Your reminder", vbYesNo + vbQuestion + _
vbDefaultButton2) <> vbYes Then Cancel = True
End Sub