Shutting Down

mrbeanyuk

Board Regular
Joined
Nov 30, 2005
Messages
214
Office Version
  1. 365
Platform
  1. Windows
Hi there. I am trying to write a macro that when you click a button the application saves and closes down.

I cant seem to get anywhere with it.

Grateful for some help and where I would put the VB coding in the spreadsheet

Thanks
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Code:
Sub test()
    ActiveWorkbook.save
    ActiveWorkbook.Close
End Sub

place it in this workbook in VBA

hth

N
 
Upvote 0
How does this activate? How do I link it to a button/

thanks v much
 
Upvote 0
If you are placing buttons on the worksheet using the forms toolbar or the drawing toolbar then you can simply right click on the button and go Assign Macro.

Richard
 
Upvote 0
if you have a button on your sheet, right click it and select "assign macro"
from the box that appears select the macro called test. Then when you click on the button in the future, the macro will run

HTH

N
 
Upvote 0

Forum statistics

Threads
1,218,541
Messages
6,143,102
Members
450,463
Latest member
DaveG999

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top