Changes not saved in xla module
Hi Tom - thanks for your reply.
I save the Addin by clicking on the disk icon on the standard toolbar in the visual basic editor. I make sure first that the floating message tells me it will save Module.xla. Regards Andrew Bourke Tom Ogilvy wrote: How do you specifically save the Addin after making changes (in the case where it doesn't work). |
Changes not saved in xla module
ahh.. but that can be a problem. VBeditor sometimes refuses to save an xla when you press that button. and will give no warning:( I know.. Excel and VBE are very mature programs and you'd expect these bugs to be fixed. Mail BillG with complaints :) I always watch the statusbar to see if it indicates that excel is actually saving the xla. To be absolutely su activate the addin in Project explorer type thisworkbook.save in immediate window. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Ajtb wrote : Hi Tom - thanks for your reply. I save the Addin by clicking on the disk icon on the standard toolbar in the visual basic editor. I make sure first that the floating message tells me it will save Module.xla. Regards Andrew Bourke Tom Ogilvy wrote: How do you specifically save the Addin after making changes (in the case where it doesn't work). |
Changes not saved in xla module
Thanks for the tip re the Immediate Window - that does save the changes.
keepITcool wrote: ahh.. but that can be a problem. VBeditor sometimes refuses to save an xla when you press that button. and will give no warning:( I know.. Excel and VBE are very mature programs and you'd expect these bugs to be fixed. Mail BillG with complaints :) I always watch the statusbar to see if it indicates that excel is actually saving the xla. To be absolutely su activate the addin in Project explorer type thisworkbook.save in immediate window. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam |
All times are GMT +1. The time now is 01:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com