Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Disable program

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Disable program

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Kalyan" <kalyan schrieb im Newsbeitrag
...
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.

Kalyan


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene LunaMoon Excel Discussion (Misc queries) 0 July 28th 08 11:03 PM
My program SM Excel Worksheet Functions 2 October 22nd 05 04:52 AM
My Program SM Charts and Charting in Excel 1 October 21st 05 09:48 PM
how do i disable "running virus scan" in excel program when opened Tammy New Users to Excel 1 June 10th 05 08:48 PM
merging excel program with tdc finance program judy Excel Programming 0 November 5th 03 08:01 PM


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"