By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,965 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,965 IT Pros & Developers. It's quick & easy.

Activate a Macro when closing excel

AllusiveKitten
P: 43
HI

I have been writing macro's using VB for one of my excel spreadsheets, in the macro I have deleted lines and sorted columns. Is it possible to write code for this to activate when you are closing the spreadsheet?

Thank you for your assistance.

AK
Apr 16 '07 #1
Share this Question
Share on Google+
1 Reply


Denburt
Expert 100+
P: 1,356
You can use the following snippet.

Workbook.BeforeClose Event

If you would like more info:
http://msdn2.microsoft.com/en-us/lib...se(VS.80).aspx
Apr 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.