As far as that goes:
Once you save the file in .xlsx format, all macros are removed.you can then
save it back to the original format and delete the .xlsx file.That way any
shortcuts or links remain functional.
of course, if the original file already IS in .xlsx format, it can be skipped,
since i
Thanks.
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Mon, May 9, 2016 at 8:05 PM, Paul Schreiner
wrote:
> The only way I can think of immediately is to use Excel 2010 or 2013 and
> have a macro that opens all excel files on a computer and saves the file
> in .xlsx format.
> Y
The only way I can think of immediately is to use Excel 2010 or 2013 and have a
macro that opens all excel files on a computer and saves the file in .xlsx
format.You can turn off prompts by using Application.DisplayAlerts = false
Your macro should also disable automatic macros when opening the f
Thanks but I want to remove macros not only from a workbook but also from
all the excel files available in that computer.
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Tue, May 3, 2016 at 10:57 AM, Abhishek Jain
wrote:
> http://excelribbon.tips.net/T010656_Removing_All_Macros.h
http://excelribbon.tips.net/T010656_Removing_All_Macros.html
On Tue, May 3, 2016 at 10:18 AM, Pravin Gunjal wrote:
> Thanks Mr.Abhishek but it's not helpful. Is there any file or something
> else by opening that all the macros from all excel files will be removed
> once in all.
>
> Pravin.
>
>
>
Thanks Mr.Abhishek but it's not helpful. Is there any file or something
else by opening that all the macros from all excel files will be removed
once in all.
Pravin.
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Mon, May 2, 2016 at 6:07 PM, Abhishek Jain
wrote:
>
> http://www.
http://www.mrexcel.com/forum/excel-questions/518757-delete-all-macros-workbook.html
On Mon, May 2, 2016 at 5:41 PM, Pravin Gunjal wrote:
> Hi, Good Evening
>
> I would like to know whether is there any provision to remove all macros
> from all the excel files on a computer?
> Kindly share your i
Hi, Good Evening
I would like to know whether is there any provision to remove all macros
from all the excel files on a computer?
Kindly share your inputs. Thank you,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
