H
Heath
Occasionally when I implement my Excel 97 Add-ins to my
colleague’s computers
they receive an error when trying to use the functionality’s
from a button.
When they click the button they receive an error that says that the
file they
trying to access is already open.
When I go in and look at how the macro is assigned it is assigning the
full
path to the workbook.
I know that if I reload the buttons when Excel opens I don't have any
problems,
but is there a way to keep this from happening?
I suppose it would have to do with qualifying the following code:
With ExcelButton
.OnAction = "PasteFormulaFormat"
End With
I am not sure exactly what will fix this.
Any help would be appreciated (or if you can directly me to an old
article that covers this)
Heath
colleague’s computers
they receive an error when trying to use the functionality’s
from a button.
When they click the button they receive an error that says that the
file they
trying to access is already open.
When I go in and look at how the macro is assigned it is assigning the
full
path to the workbook.
I know that if I reload the buttons when Excel opens I don't have any
problems,
but is there a way to keep this from happening?
I suppose it would have to do with qualifying the following code:
With ExcelButton
.OnAction = "PasteFormulaFormat"
End With
I am not sure exactly what will fix this.
Any help would be appreciated (or if you can directly me to an old
article that covers this)
Heath