Chris, first can you explain what you want to achieve with the sheet change
event. We can then decide on what kind of event and the level of the event
required. For example, if you just want to know whether the users switched
from your workbook to another workbook, you don't need a sheet event, but a
workbook event, like Workbook activate or deactivate.
Regards.
Sam Mathai Chacko (GL)
On Tue, Oct 25, 2011 at 9:48 PM, Chris Boxall wrote:
> My macro needs to know when the user changes sheet.
>
> ** **
>
> I have located the Workbook_SheetActivate event but I’m confused as where I
> place this.
>
> ** **
>
> If I place it in a code module in my macro it does *not* get executed.
>
> ** **
>
> If I place it in ThisWorkBook of my macro it does get executed when I
> change sheet within *my macro’s* workbook. However, it does *not* get
> executed when the user changes sheet within *his* workbook.
>
> ** **
>
> What am I missing? Is there any documentation on this that you can point
> me to please?
>
> ** **
>
> Chris Boxall
>
> ** **
>
> ** **
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Sam Mathai Chacko
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
