Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default start a macro when file opens??

Hi all
is there any way to start a few lines of code
whether in a macro or ????

I need this to run automatically when the file is opened

trying for little user interaction as possible
as in this case no hands - for handicapped person

most cells input will be voice activated
but I cant quite get the 2 macros to start re voice

TIA



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 73
Default start a macro when file opens??

See my reply in excel.misc
"Ftca" wrote in message
...
Hi all
is there any way to start a few lines of code
whether in a macro or ????

I need this to run automatically when the file is opened

trying for little user interaction as possible
as in this case no hands - for handicapped person

most cells input will be voice activated
but I cant quite get the 2 macros to start re voice

TIA





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default start a macro when file opens??

Use the Workbook_Open macro on the Workbook in the VBA
editor.

Double click the ThisWorkbook object. In the code window, at
the top, on the left, select, from the drop down box, Workbook.
In the right drop down box on the top right it should default to
Open - if it does not then just select Open from this box.
Write your code in that sub.

Some versions of Excel are a little different but I have only one
version running right now and cannot remember what you do in
those but it is not too dissimilar - in some IIRC an macro called
AutoOpen will run when the workbook is opened.

Chrissy.

Ftca wrote
Hi all
is there any way to start a few lines of code
whether in a macro or ????

I need this to run automatically when the file is opened

trying for little user interaction as possible
as in this case no hands - for handicapped person

most cells input will be voice activated
but I cant quite get the 2 macros to start re voice

TIA





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
writing a macro that automatically opens another file J.Mart[_2_] Excel Discussion (Misc queries) 3 August 12th 08 10:44 PM
macro that opens file named in cell doesnt work Illuminati Excel Worksheet Functions 2 November 15th 07 11:49 AM
File opens with Enable or Disable Macro animalfriend7 Excel Discussion (Misc queries) 1 November 8th 06 04:29 PM
Excel macro that opens new MS Word file and pastes data as a pictu Rob Excel Worksheet Functions 0 July 6th 05 05:12 PM
Hide Enable/Disable Macro pop-up when file opens steve Excel Worksheet Functions 3 April 12th 05 04:50 PM


All times are GMT +1. The time now is 02:44 PM.

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"