this may help with disabling print button on toolbar use the vba in this link
http://answers.microsoft.com/en-us/o...9b31bf5?auth=1
then create a button and add a VBA (example below)
Sub PrintDaily()
Range("PrintTble").Select
MsgBox "This is a message!", , "This is the Title"
ActiveSheet.PageSetup.PrintArea = "PrintTble"
ActiveSheet.PageSetup.BlackAndWhite = True
ActiveSheet.PageSetup.FitToPagesWide = 1
ActiveSheet.PageSetup.FitToPagesTall = 1
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub
Someone with greater knowledge could tidy it up
Bookmarks