Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default TRIGGER MACRO ON FILE OPEN

I am trying to create a macro that will trigger when I open a workbook, but I
am not at all familiar with Visual Basic. Is there a way to do this without
writing VB code?

Thanks!
--
Drew
  #2   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default TRIGGER MACRO ON FILE OPEN


"Drew" wrote in message
...
I am trying to create a macro that will trigger when I open a workbook, but
I
am not at all familiar with Visual Basic. Is there a way to do this
without
writing VB code?

Thanks!
--
Drew


Drew

Are you familar with the visual Basic editor.? If so
you need to place code in the workbook_open event .

Private Sub Workbook_Open()

your code

End Sub

Such a macro would fire every time to load the workbook

Best N10




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Excel file from VB and open MACRO no1jimmyman Excel Discussion (Misc queries) 0 February 14th 11 10:10 PM
Open a file do a macro ( made) and open next succesive file SVTman74 Excel Programming 5 April 21st 06 10:14 PM
Macro to call a file that has a auto open macro in the file itself [email protected] Excel Programming 1 August 5th 05 06:39 AM
Automate open file, update links, run macro, close and save file Geoff[_7_] Excel Programming 2 August 26th 03 10:13 PM


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"