Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
distributing days | Excel Worksheet Functions | |||
Distributing secure ('er') Excel workbook | Excel Programming | |||
distributing add-ins | Excel Programming | |||
distributing a macro | Excel Programming | |||
Distributing code | Excel Programming |