Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 4th, 2006, 03:54 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default first event

Hi,

Please could someone tell which is the first event that hapens when excel file is opening and in which all elements are accessible. I have to script smth. where I have to set some values which are set only once and that is on opening of document.

thanx in advance

regards

regards
__________________
regards
 
Old September 6th, 2006, 05:50 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 173
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Not sure if you've already got this but
Code:
Private Sub Workbook_Open()
is the event you're looking for.

Maccas

 
Old September 7th, 2006, 02:13 AM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanx Maccas it works

regards





Similar Threads
Thread Thread Starter Forum Replies Last Post
Event - Sender & Event args dash dev C# 2005 9 December 9th, 2007 07:24 AM
Event Firing tobriain C# 1 June 12th, 2007 08:19 AM
What Event Exactly? Macsood ASP.NET 1.0 and 1.1 Basics 6 October 26th, 2005 09:24 AM
About Button event and Keydown event zhangxujun1981 XSLT 1 March 6th, 2004 04:59 AM
how to override an event with an event? blah VB.NET 2002/2003 Basics 5 November 13th, 2003 03:06 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.