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 |
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/ |
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 |
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