ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Distributing Workbook (https://www.excelbanter.com/excel-programming/307898-distributing-workbook.html)

halem2[_14_]

Distributing Workbook
 
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

--
Message posted from http://www.ExcelForum.com


mark

Distributing Workbook
 
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
"halem2 " wrote in message
...
Hi:

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

Any clues?


---
Message posted from http://www.ExcelForum.com/




halem2[_15_]

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


thank

--
Message posted from http://www.ExcelForum.com


mark l

Distributing Workbook
 

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!


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com