LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default Unhook (then rehook) workbook events???


I'm working with an application which automates Excel to host a "Report"
workbook. There are various types of "sessions" during which a user can
interact with the workbook in a more or less limited way (eg. saving of the
workbook under another name is not permitted).

It seems that in one particular session type the controlling application has
hooked the Workbook_Beforesave event such that choosing "Save" from the
Excel menu calls a particular piece of code but does not save the workbook.

Anyone know whether it's possible (without access to the controlling code)
to "unhook" the Beforesave event temporarily so that I can save the
workbook, and then "rehook" the event ?

Thanks for any ideas,
Tim.


 
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
Understand Workbook/Worksheet Events Zamdrist Excel Discussion (Misc queries) 4 August 10th 06 04:56 PM
Detect workbook events from .XLA Conceptor[_2_] Excel Programming 2 October 27th 03 07:05 PM
Workbook-Events donīt work with ChartObjects geissma Excel Programming 0 September 16th 03 01:09 PM
Workbook Events Geoff[_8_] Excel Programming 0 September 13th 03 09:28 AM
Events for workbook close Aaron Queenan Excel Programming 6 July 15th 03 09:09 PM


All times are GMT +1. The time now is 12:37 PM.

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

About Us

"It's about Microsoft Excel"