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: 137
Default Restrict Worksheet_Calculate() to its original worksheet !!!

Hi,

I have to use worksheet calculate to fire a couple of macros.
The problem is that, at a later stage, another workbook is opened, and
worksheet_calculate() fires automatically in the newly opened workbook.
So far, I had no success in adding a trap such as :
If ActiveSheet.Name <"xxxx" Then exit sub ...
Any suggestions ???
Thanks in advance
Carim

 
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 restrict the view of a worksheet Romileyrunner1 Excel Worksheet Functions 1 October 4th 09 04:43 PM
Password Restrict a Worksheet for Viewing Annie V Setting up and Configuration of Excel 2 September 11th 08 02:52 AM
how do I restrict access to only one worksheet in excel? Avinash Excel Discussion (Misc queries) 5 March 21st 06 03:28 AM
restrict changes to worksheet EdWeitz Excel Discussion (Misc queries) 1 January 31st 05 03:41 PM
Update second worksheet with changes in original worksheet ZB Excel Worksheet Functions 0 January 26th 05 06:11 PM


All times are GMT +1. The time now is 09:11 AM.

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"