I have a 2 MB workbook containing multiple sheets, formulas. A toolbar have been also implemented and status bar also is being used in VBA code.
My problem is that I try to save the excel file, it takes too much time(around 40 sec) in saving. Machine also hang-ups when this excel file is being saved. Initially I thought that Workbook_BeforeSave() takes much time,but after analyzing I came to know that this function also consumes very less time(around 1 sec). Please help me to solve this issue. Thanks in advance, Harish --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
