View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mr_teacher[_2_] mr_teacher[_2_] is offline
external usenet poster
 
Posts: 1
Default Auto run macro on individual worksheet open


Hi all

Apologies if this is elsewhere - had a look through but couldn't fin
an answer but I am a newbie so please bear with me!:)

I am attempting to automatically run a Macro in Excel when i open
worksheet but can't find a way to do this. I know I can have one set t
run when the whole workbook opens, but I need to have a different macr
running when different worksheets open and each time that an individua
worksheet is opened without closing down the whole workbook - basicall
to return to cell A1 on open (but it may not always be A it needs to g
to if that sheet is using a VLOOKUP and has numbers in the column)

Thanks for any help / advice you can offe

--
mr_teache
-----------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=54124