Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make a custom menu available to other users of
I made a custom menu in a workbook that I need to email to others. When I
tested emailing it to myself on a different computer, the custom menu item disappeared. When I picked it up on the original computer, The macros associated with the menu items didn't work, Excel said it was looking for the macros in the worksheet on my hard drive (from the copy I emailed to myself). Very perplexing.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
make a custom menu available to other users of
Here are some notes about this from J K Pieterse
Many users tend to put their macros in their personal.xls file. Nothing wrong with that, because that is what it is there for. But what if you like your macros so much you decide others might benefit? You might be tempted to copy your personal.xls onto a floppy and give that to others. Don't! Also don't copy your xlb file to others to give them your toolbars, you will overwrite their customisations.. I would be very distressed if you would come and hijack my personal.xls and excel.xlb files! What you should do is create a new workbook with all your code *and toolbars* and distribute *that* file (maybe saved as add-in). About toolbars: You can attach a toolbar to a workbook. When this workbook is loaded, XL checks if the toolbar is on the system. If not, it copies the toolbar from the workbook to the system. After creating *or changing* the toolbar, you should attach the toolbar to your workbook: - activate the workbook to which you want to attach the toolbar - Rightclick the toolbar, select 'customise' - Click 'Attach' (Toolbars Tab) - If the workbook already contains a toolbar by that name, delete it first by clicking on it on the righthand side and choosing Delete. - Select your toolbar (on the left) and press 'copy' - Save the workbook (optionally: save_as an add-in). Also, You should include code that deletes the toolbar when your workbook or add-in is closed, so that when you deliver a new version of your workbook the new toolbar will be used i.s.o the old one. You can do that in the Thisworkbook module, using the Workbook_beforeClose event: Private Sub Workbook_BeforeClose(Cancel as Boolean) On Error Resume Next 'In case Toolbar is absent Application.CommandBars("YourB*arsName").Delete End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Anthony Ponton" <Anthony wrote in message ... I made a custom menu in a workbook that I need to email to others. When I tested emailing it to myself on a different computer, the custom menu item disappeared. When I picked it up on the original computer, The macros associated with the menu items didn't work, Excel said it was looking for the macros in the worksheet on my hard drive (from the copy I emailed to myself). Very perplexing.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can custom views be opened in a worksheet by other users? | Excel Discussion (Misc queries) | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
custom charts not accessable to all users. | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming | |||
VBA-Make Custom Menu Item Fire | Excel Programming |