Problem assigning macro to button?

[ltickett]

I have a workbook which is used by 100+ users across the country. So fa
the workbook has been in place for 1month and I've had 2 user
experience this problem...

-> The user clicks a button on the main workbook which opens anothe
workbook (works fine!).
-> Within this new book the user now fills out some information the
clicks a button to save, summarise and close the workbook (VBA macro
This is where sometimes a problem arises...

The macro which is assigned to the button resides in the main workboo
and on occasions when the user clicks the button a small box pops u
asking for the write access password to the main workbook or if th
user wishes to open with Read-Only access. Entering the password o
clicking the Read-Only button both result in an error saying the macr
couldnt be located! After which the main workbook is no longer open?!

I'm having real difficulty working out what the problem is as the mai
workbook is ALWAYS open. So there should be no reason for the promp
for password/read-only! But once the prompt has come up the mai
workbook is then closed?!

The only current way i've found to overide this problem is to manual
execute the macro; clicking tools, macro, macros, locate the relevan
macro, edit, F8 then F5.

If i try just to goto tools, macro, macros, locate the relevant macr
then hit run I get exactly the same problem as when pressing the butto
which should execute the macro!

 

[mangesh_yadav]

did you try assigning the entire path to the button somthing like:

file_name!macro_name

- Manges

 

[ltickett]

Hmm, well I already had it setup like that...

'filename.xls'!macro_name

So i dont think that can be it... and i think i've already eliminate
the possibility of it being the way the macro is assigned to th
button. Because if the user goes to Tools > Macro > Macros then locate
the macro and hits run it doesn't even work!