MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

how to Add Close File Button

  Asked By: Chisisi    Date: Nov 24    Category: MS Office    Views: 836

I want to add a close file button in cell g:19 or any where in excel
spread sheet... can any one help me..



1 Answer Found

Answer #1    Answered By: Haboos Kauser     Answered 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

Close the control toolbox

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