Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom ToolBars
Have created two custom toolbars in Excel with macros
attached to the buttons. The macros, written in VB, are contained in personal.xls When I try to run these buttons, I frquently get the message "Document with the name Personal.xls is already open" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom ToolBars
check you location of personel book.. you must be having two books i
different folders. better way is to save your workbook as addins and then browse an select the addin .. other way is to give reference to your workbook from vba.. so th workbook where you want to use your macros..this prevents every time workbook to be open -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Custom Toolbars | Excel Discussion (Misc queries) | |||
Custom Toolbars | Excel Worksheet Functions | |||
Custom Toolbars..? | Excel Discussion (Misc queries) | |||
Custom Toolbars - keep dissappearing | Excel Discussion (Misc queries) | |||
Custom toolbars | Excel Discussion (Misc queries) |