Macros Excel personal.xls loading

[KeithM]

Hi,

We have some vba Macros and buttons that our customer base uses to format
some
of their xls documents.

I have created these macros in the personal.xls file and then I ensure that
this file is copied into the users profile area in the XLSTART directory at
logon.

The trouble is the users complain that when they launch Excel they get a
window opening for the personal.xls file.

I would like the users to be able to use the macros without the personal.xls
window opening, is this possible?

Its Office 2003.

Thanks

(x-posted to microsoft.public.office)

 

[Phil]

You'd be better off putting the code in an addin. Save the workbook
containing your macros as an xla file.

 

[Jialiang Ge [MSFT]]

Hello KeithM

From your post, my understanding on this issue is: you deploy your Excel
macros from a central file: personal.xls, but when your users launch Excel,
they get a window opening for the personal.xls file. If I'm off base,
please feel free to let me know.

According to the document
http://office.microsoft.com/en-us/excel/HA010872961033.aspx (Deploy your
Excel macros from a central file):
"You keep personal.xls hidden unless you want to add macros to it. Whenever
you start Excel, personal.xls opens automatically and runs in the
background. If you don't hide the file, Excel opens it and allows you to
add data to it."
Thus, my guess is that your personal.xls itself is not set to be hidden,
please check it and let me know if it works.

Phil's suggestion is very valuable, too. You may also resolve the problem
by creating an add-in as Phil said.

Sincerely,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jialiang Ge [MSFT]]

Hi KeithM,

Would you mind letting me know the result of the suggestions? If you need
further assistance, feel free to let me know. I will be more than happy to
be of assistance.

Have a great day!

Sincerely,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[KeithM]

My humble apologies for taking so long to reply.
I have been using my newsreader wrong and did not think I had recieved any
replies.

I will try this fix tomorrow and post my results as soon as possible.

Thankyou.

 

[KeithM]

Hi,

I have tried your suggestion and made the personal.xls file hidden.

When I then run Excel the macros I have deployed in it do not appear in the
Macros list in Excel and the custom buttons I create also do not appear.

I removed the hidden attribute and re-opened excel and the macros reappear
along with the buttons but as mentioned I then get personal.xls opened as a
window.

Can you advise?

 

[KeithM]

Sorry, I did not read the article at first, and simply used Windows Explorer
to Hide the file.

I have now tried using the Hide Window command from within Excel and now all
works as desired.

Thankyou for your help.

 

[Jialiang Ge [MSFT]]

Hello KeithM,

I am glad to see you've resolved the issue. You are always welcome here.

Have a great day!

Sincerely,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.