Recent content by memberlogin

i have written a program to CD that works fine until I change drives, is is possible to have a macro that will look for the prog on any drive so that it would work on any machine? e.g my main drive is the D: and if I put it my writer then it would be my F: drive.

how can you get a user form to start up automatically in word by just opening a word document?

is it possible to turn off the copy function and also disable the ability to change the footers in Word?

is it possible to create a word document with a footer already entered and stop a user changing the footer?

I would like to start a front end in Word, one that uses links to other documents and one that is protected from change once it is avialable not using passwords.

How can i run s macro when a cell is selected that is based on the contents of the cell. e.g. summarize in another sheet totals based on the name of the cell

How can i run s macro when a cell is selected that is based on the contents of the cell. e.g. summarize in another sheet totals of the name of the cell

how can I run a macro bsed on which cell has been selected and using the contents of the cell to summaries all occurances of Cell contents choice!

at the start of the Query I did ask for closed workbooks! as I know how to referance data from one worksheet, or workbook myself. I am trying to get simple VBA macro to enable me to Help out a friend who has Data in various sources.

How could I get Data from a several closed workbooks and take the information from worksheets in those workbooks, and then put the infromation into a new worksheet (a summary sheet) just by putting the workbook names into Cells of a workbook. I hope this make sense!

I am sorry if I mislead you but the worksheets are in different Workbooks so the line:- ThisWorkbook.Sheets("sheet_name").Activate would not work!!

How can I find out if an Excel worksheet exists before running a macro so as to avoid an error?

the prog is for for a friend, the months are in separate worksheets, I do not have a problem with correlating the data that way. it is when the worksheets are sometimes differant from one moth to the next I need to know a way of finding the names of worksheets. month are on differant workbooks...

is it possible to correlate the contents from differants workbooks that have the same format but differant worksheets and are Variable to one work sheet at the end of a work period, eg. three months sales by salesmen into end of qtr slaes? These figures are in Excel and a solution for Excel VB...

How do you Make it so User Forms in Excel's Visual Basic do not move? I have set the border status to no border yet it still moves!