Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Chisisi Massri   on Nov 24 In MS Office Category.

  
Question Answered By: Haboos Kauser   on Nov 24

Right click a blank spot in the Toolbar area. Click "Control Toolbox"

Click the image of a button

Click and drag in your worksheet where you want the button

Double click the button  - this will take you to the VBA editor and
generate a sub

Type "ActiveWorkbook.Close" without the quotes

Close the VBA Editor window

Click the top left button in the control toolbox to take you out of design
mode

Close the control toolbox

Share: 

 
 
Didn't find what you were looking for? Find more on how to Add Close File Button Or get search suggestion and latest updates.


Tagged: