Posted to microsoft.public.excel.programming

Kari J Keinonen[_2_] Kari J Keinonen[_2_] is offline

external usenet poster

Posts: 20

Addin close command not working in new workbook

Hi!

I'm not sure what you need, but try this one.

Private Sub workbook_beforeclose(cancel As Boolean)
Application.DisplayAlerts = False
Workbooks("YourWorkbookName").Sheets("What If").Delete
Application.DisplayAlerts = True
ActiveWorkbook.Save
End Sub

Regards,
Kari J Keinonen

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to close an Addin?	FARAZ QURESHI	Excel Discussion (Misc queries)	5	June 4th 09 01:15 PM
VBA Code to kick off macro when workbook command to close is initi	zulfer7	Excel Discussion (Misc queries)	2	June 23rd 06 08:04 PM
Deleting Command Bars on close of a workbook	Stan Bottorff	Excel Programming	1	November 6th 05 04:13 AM
Executinh Addin Sub Menu Command	Amir	Excel Programming	1	August 21st 05 02:30 AM
Addin Close problem	S G Booth	Excel Programming	1	February 13th 05 03:05 PM

All times are GMT +1. The time now is 09:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us