Posted to microsoft.public.excel.programming

Andy

external usenet poster

Posts: 2

All sheets calculate after saveas

I am using Excel via automation with vba and handling sheet calculate
events to handle changes made to the sheet. However, following a saveAs
for the workbook a sheet calculate event occurs for all the sheets. Is
there a way I can prevent this from happening.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Calculate individual sheets?	Jase	Excel Discussion (Misc queries)	1	April 2nd 09 05:32 PM
Calculate data from different sheets	Stefan	Excel Discussion (Misc queries)	4	April 1st 09 12:30 PM
new sheets by this pc cannot calculate formulas	Jeffry61	Excel Discussion (Misc queries)	12	September 23rd 05 07:21 PM
Calculate all sheets	Pat	Excel Programming	1	January 17th 05 05:36 PM
Calculate Individual Sheets	PosseJohn	Excel Programming	2	December 12th 04 08:18 PM

All times are GMT +1. The time now is 05:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us