ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Action on sheet Selection (https://www.excelbanter.com/excel-programming/331105-re-action-sheet-selection.html)

Piranha[_9_]

Action on sheet Selection
 

jpizzle Wrote:
Hello everyone, Im back for another probably easy question. How would I
get excel to preform a certain action, or macro, when a specific sheet
is selected? Thanks again everyone!

Hi jpizzle,
example, (put in Sheet module):

Private Sub Worksheet_Activate()
MsgBox "Hi"
End Sub

Thx
Dave


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=376995



All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com