excel toolbar problems

C

chief

I am trying to set up a shortcut of my file on another workers compute
who has excel, but when I open up excel there is no menu bar or toolba
at the top. Also when I open my file it doesn't allow the macros t
run. Why and what can be done?

thank
 
D

Dave Peterson

First, the easy one.

Macros can represent a security risk. Therefore, MS has set the default
behavior of excel to prohibit macros from running.

Tools|macros|Security|Security level
is how I would change it in xl2002.

xl2k has 3 levels of security (high, medium, low). High stops everything.
Medium prompts you each time a workbook with macros is opened and low (not
recommended by MS) allows everything to run.

xl97 has 2 levels (IIRC)--either on or off.

=====
If that coworker is missing all the toolbars, make sure that they're not just
off the screen.

Rightclick on the excel icon in the windows taskbar and select Maximize (if not
already maximized).

Do you see the toolbars now?

If no, you can reset them (and lose any changes that you co-worker made) by:

close excel
windows start button|find (or search)
look for *.xlb (for hidden files in hidden folders)
rename all the *.xlb's you find to *.xlbOLD

then back to excel to test it out.

If it helped, delete the *.xlbOLD's. If it didn't, rename them back to *.xlb.

====
I'm not sure what a "shortcut of my file" really means. But if you're sharing a
custom toolbar, you may want to attach it to a workbook that contains the
macros.

If you do this, read Jan Karel Pieterse's notes at:
http://google.com/[email protected]
 
C

chief

Thanks for the help, it worked great. I do have a new problem whic
seems to be coming up. I have a userform set up called "Password
which I have set up in my vba project in the "This Workbook" Shee
under Excel Objects. It is set up to show as soon as the file i
opened as:

Private Sub Workbook_Open()

Password.Show

End Sub

This way, when someone types in their name and clicks OK they will b
put through to the inventory sheet.

Now, it will work no problem on a few computers, but there are tw
computers which asks you to debug the Private Sub Workbook_Open()?
checked the macros and they are functionally able to work if the perso
clicks on various command buttons, but it's just the beginning wher
this password won't run properly? Can someone give me a hand please?

Thank
 
D

Dave Peterson

I've seen a few posts that suggest that workbook_open and auto_open can have
timing trouble when you're opening the workbook.

This might not even be close to the problem/solution, but maybe you can try
this:

Private Sub Workbook_Open()
Application.OnTime Now, "Continue_Open"
End Sub

Then in a General module,

sub Continue_Open()
password.show
end sub

===
You sure there isn't anything in the userform code that's screwing things up
(maybe if the user gives an invalid answer????).
 
Top