Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default view code in excel sheets


Hi all

When you want to run a macro for a certain sheet continously you righ
clight the sheet tab and then click on view code and insert the macr
there.

Is there an equivalent for word documents and in fact is it possible t
have a macro run when ever word opens?

Thank

--
jim2

-----------------------------------------------------------------------
jim27's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=31985

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default view code in excel sheets


Open a word document

macros for word works exactly same as excel

goto - tools-macro-visual basic editor, double click "this document
below project (file name)

paste this code

Private Sub Document_Open()
MsgBox "document opened"
End Su

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=31985

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
Is it possible to view two sheets at once in Excel? Craisin Setting up and Configuration of Excel 2 February 22nd 07 11:04 PM
Help! Lost sheets by using View Code on worksheet tab Michele Excel Discussion (Misc queries) 3 November 29th 06 08:16 AM
Permissions to view only certain sheets in Excel Michael C Setting up and Configuration of Excel 2 March 16th 05 12:45 AM
Tree View for excel sheets c2k2000 Setting up and Configuration of Excel 10 December 24th 04 06:01 PM
view code in excel sheets crispbd[_36_] Excel Programming 0 November 23rd 04 08:21 PM


All times are GMT +1. The time now is 06:20 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"