ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Removing macros from workbook (https://www.excelbanter.com/excel-discussion-misc-queries/48425-removing-macros-workbook.html)

Darrell

Removing macros from workbook
 
Hello
Is there a quick and easy way to remove all macros from a workbook I receive
from others? I find that, if I accept these, all of my custom toolbar
buttons that call up my own macros get "re-mapped" and I have to go in to
every one manually and re-assign macros to them.



Myrna Larson

If your security settings are set to Medium or High before you open such a
book, you will have the option to not run its macros (or, with High they won't
run, period).

On Tue, 04 Oct 2005 01:16:23 GMT, "Darrell"
wrote:

Hello
Is there a quick and easy way to remove all macros from a workbook I receive
from others? I find that, if I accept these, all of my custom toolbar
buttons that call up my own macros get "re-mapped" and I have to go in to
every one manually and re-assign macros to them.



All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com