Programming commands

  • Thread starter Thread starter CP
  • Start date Start date
C

CP

I have just added a couple of buttons to my work book and i wish them to
carry out two tasks
The 2 buttons are on sheet1

1) print sheet3 to default printer
2) close excel without saving or asking to

I am ok with getting to the coding screen however I just dont know what to
write in the visual basic box to perform the tasks

Thank you
 
1.
Sheets("sheet3").PrintOut (beware of the case)
2.
Application.DisplayAlerts = False
Application.Quit
 
Hi

With the two buttons named CommandButton1 and 2 insert theese two
macros in the codesheet for sheet1

Private Sub CommandButton1_Click()
Sheets("Sheet3").PrintOut
End Sub

Private Sub CommandButton2_Click()
ThisWorkbook.Close Savechanges = False
End Sub

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to read and find a name? 5
Command Button and macro 4
Access Automatically Send a notification email once a record is added 0
Check for two sheets. Add or subtract as necessary. 2
Indirect formula not working if I give custom name for Sheets 1
Printing multiple worksheets in a workbook 3
new to visual basic...help appreciated 2
renaming worksheets by date value 3

Back
Top