Re: $$Excel-Macros$$ Need Help for Data

2016-12-19 Thread vikas khen
Hi Team Any update regarding on the same?? Regards, On Mon, Dec 19, 2016 at 9:51 AM, vikas khen wrote: > Hi all, > > Good Morning!!! > > Team, need help for pooling data from Outlook2016 mails (Which is I kept > in the one folder) to Excel Sheet in Desired format. > > my mail contains followin

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-19 Thread rogergov...@googlemail.com
Hi Vijay In the Thisworkbook module, I added these two macros Private Sub Workbook_BeforeClose(Cancel As Boolean) HideAllSheets End Sub Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) HideAllSheets End Sub and in the Module 1, I entered Sub HideAllSheets() Di