Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Open sheet function
I'm curious, is it possible to set a program to run each time a sheet i accessed? I imagine it would be similiar to: Private Sub Workbook_Open() End Sub Perhaps: Private Sub WorkSheet("name")_select() End Sub etc... Is this a do able task -- wilro8 ----------------------------------------------------------------------- wilro85's Profile: http://www.excelforum.com/member.php...fo&userid=2693 View this thread: http://www.excelforum.com/showthread.php?threadid=45139 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Open sheet function
Right click the sheet tab in question and select View Code. Then:
Private Sub Worksheet_Activate() 'your code here End Sub Hope this helps Rowan "wilro85" wrote: I'm curious, is it possible to set a program to run each time a sheet is accessed? I imagine it would be similiar to: Private Sub Workbook_Open() End Sub Perhaps: Private Sub WorkSheet("name")_select() End Sub etc... Is this a do able task? -- wilro85 ------------------------------------------------------------------------ wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935 View this thread: http://www.excelforum.com/showthread...hreadid=451397 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why, when i open a work sheet does a blank sheet open as well | Excel Discussion (Misc queries) | |||
open up an excel program with an auto open macro | Excel Programming | |||
auto update an open excel sheet over network, with mutiple users | Excel Worksheet Functions | |||
auto name sheet w/ macro or function | Excel Programming | |||
Auto Open Excel at Specific Sheet | Excel Programming |