If the macro is in a module in your workbook/file it will go with the file and
other users can use it.


Gord

On 15 Jan 2007 15:02:59 -0800, wrote:

It is working fine on my computer. If I give the file to someone else
to use on their computer, will the macro transfer with the file so that
they can use it also?

24t42




wrote:
I want to thank both of you for your help. Excel and I don't get along
too well. I don't use it often enough to be familiar with it's inner
workings.

I am glad to report that it is now working each time I open the file.
It helps if you put the code in the correct spot.

No, this file is not for my personal use. It is a score sheet that will
be used by several people on differnet computers.

Thanks, again!

Judy


Gord Dibben wrote:
If just for your own computer...........................

Check out Help on Digital Signing and the the SelfCert utility which allows you
to sign your projects on your own computer only.

Self-cert digital signatures are not exportable as are paid-for ones from Thawte
and Versisign.

Go to StartProgramsMicrosoft OfficeOffice ToolsDigital Certificates and
build a selfcert from there.

When complete and your workbook is open go to VBEditor and ToolsDigital
SignatureChoose.

Select the one you just created and Ok your way out.

Save the workbook and re-open. Click "Yes" when asked about "trusted whatever".

You won't see the macro message again for that workbook.

You can use the signature for all your workbooks with macros.


Gord Dibben MS Excel MVP

On 15 Jan 2007 10:22:21 -0800, wrote:

Problem #1 -fixed. My worksheet is not named sheet1. As soon as I
changed it, it worked.

Problem #2 - fixed. Captain Dum Dum here. I did not notice that it was
not saving as Excel workbook. As soon as I changed that, it worked.

Now, one more question. Now when I open the file, I get the security
warning about macros. Is there a way to turn this off or is it
something I must live with.

Thanks for all your help.

24t42




wrote:
Dave,

Thanks for the quick reply but I must be doing something wrong. I have
two problems.

First - I followed the link you provided and did as they suggested for
using someone's elses macros. I only have one worksheet in my Excel
file and want it to open to Cell D5. So I used -

Option Explicit
Sub Auto_Open()
Application.Goto Worksheets("sheet1").Range("D5"), scroll:=True
End Sub

When I returned to my spreadsheet and tried to run the macro with ALT +
F8. I get the error " subscript out of range."

Second, so I thought I would save the file and go back to it later.
When I tried to save it, I got the following message -

"The following features from you workbook will not be saved in the XML
spreadsheet - VB project. Do you want to continue saving as XML
spreadsheet? Yes or no?"

I have my macro security set to medium.

Thanks in advance for any help you can give me?


Dave Peterson wrote:
You can have a macro run each time the workbook opens.

Option Explicit
Sub Auto_Open()
application.goto worksheets("sheet9999").range("x777"), scroll:=true
end sub

Change the worksheet name and cell address to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

wrote:

I would like for my Excel 2003 worksheet to open at a specific cell
reference. Is this possible.? My knowledge of Excel is very limited so
please be explicit.

Thanks in advance.

--

Dave Peterson