Arpanakumar
Member
Hello Experts.
I was asked to create some add ins which are used by staff regularly.
1) Move sheets: When we move sheets being excel files are big taking lot of time and there are so many display alerts for which continuously click ok button which takes 5 mts.
So what i need is.
When i click on Add In as button in quick access tool bar.
Should ask me to new workbook or existing based on that it should move and move the sheet with out any display alerts..
Some how we can use Application.displayalerts=True and false while moving i think.
So need our own menu or QAT with own icon setup.
Any clue?
I was asked to create some add ins which are used by staff regularly.
1) Move sheets: When we move sheets being excel files are big taking lot of time and there are so many display alerts for which continuously click ok button which takes 5 mts.
So what i need is.
When i click on Add In as button in quick access tool bar.
Should ask me to new workbook or existing based on that it should move and move the sheet with out any display alerts..
Some how we can use Application.displayalerts=True and false while moving i think.
So need our own menu or QAT with own icon setup.
Any clue?