View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ajtb Ajtb is offline
external usenet poster
 
Posts: 41
Default 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