Distributing Workbook

H

halem2

Hi:

I have a workbook that has several vb macros and I need to distribut i
to other users. I have saved all macros in "This Workbook" not in th
global. When I save that workbook to a network share and then place
shortcut on the users desktop, the workbook does not look the same i
all workstations. I have two custom toolbard and they both show BU
not all buttons in the two toolbars show.

Any clues
 
M

mark

Regarding the commandbars - just had the same problem. The way I got mine
working was to add the commandbars, buttons using VBA. Ref the button
ID's - I found that keeping the face ID numbers Low was the best way round
(0-1000), the users at my place of work are using Windows 98 - XP with
Office 97 - XP!

HTH
Mark
 
H

halem2

To deal with the command bars, this is what I did:
Application.CommandBars("Standard").Visible = False


thank
 
M

mark l

I hid all the standard worksheet bars so that mine was the only one
available but am still trying to dock it on the menu bar as at the
moment it is floating!


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top