Disable program

[Guest]

H

I need a help. Here is my situation, I have Excel Spreadsheet, When you open it, it will do manupulation and finally generate pivot table. At the end, It will spreadsheet will be saved as given file name

Here is my questio

When i saved file, all my macros/vba code is also saved in new file name. When you open saved file name, again it fired vba (because my code is in thisworkbook open_workbook). How to disable macros in new saved file

Kalya

 

[Frank Kabel]

Hi
see
http://www.cpearson.com/excel/vbe.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Hi

I need a help. Here is my situation, I have Excel Spreadsheet, When

you open it, it will do manupulation and finally generate pivot table.
At the end, It will spreadsheet will be saved as given file name.

Here is my question

When i saved file, all my macros/vba code is also saved in new file

name. When you open saved file name, again it fired vba (because my
code is in thisworkbook open_workbook). How to disable macros in new
saved file.