Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
All Tags
»
VBA
»
vbcomponent
(RSS)
Browse Site by Tags
Showing related tags and posts accross the entire site.
calculate event
codemodule
CreateEventProc
Event procedure
excel
InsertLines
Macro
security
vbe
vbide
vbproject
Worksheet_Calculate
Re: Add event to new worksheet using VBA
Hi Anonymous! This is how I would add a new worksheet and attach the "Calulate" event handler (the example shows a message box each time the calculate event is triggered): Private Sub NewSheet_Click() Dim oXl As Application: Set oXl = Application oXl.EnableEvents = False oXl.DisplayAlerts ...
Posted to
VBA
(Forum)
by
Pedro80
on Wed, Jan 9 2008
Page 1 of 1 (1 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.