ExcelBanter - Delete All Macros

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Delete All Macros (https://www.excelbanter.com/excel-worksheet-functions/208494-delete-all-macros.html)

Hardeep_kanwar[_2_]

Delete All Macros

Hi! Experts

Is it possible to Delete all Macros from all the sheets in my System without
opening the sheets.

There are few Folders in my system that is Shared and dont want to disclose
any Macros to any one. There are Thousands of worksheets and i dont know
which sheets have a Macros.

Thanks In Advance

Hardeep kanwar

Mike H

Delete All Macros

Hi,

You could stick this in a loop that loops through all workbooks in a directory

http://www.exceltip.com/st/Delete_al...Excel/505.html

Mike

"Hardeep_kanwar" wrote:

Hi! Experts

Is it possible to Delete all Macros from all the sheets in my System without
opening the sheets.

There are few Folders in my system that is Shared and dont want to disclose
any Macros to any one. There are Thousands of worksheets and i dont know
which sheets have a Macros.

Thanks In Advance

Hardeep kanwar

All times are GMT +1. The time now is 03:39 AM.