Macro button works on my pc, no-one else's

Hi all,

I have several spreadsheets with macros, which are launched using buttons. These have worked well for a long time. Now however, on one of the spreadsheets the button only works for me. For anyone else, the button doesn't even depress. Their macro security is the same as mine, and if you run the macro manually it still works - but the button doesn't.

On the other spreadsheet, the same type of button works well for everyone.

For both spreadsheets the code behind the button is essentially the same:

Please Login or Register  to view this content.

The only difference being the name of the macro called. The macro called works manually without the button.

Any ideas anyone?

Thanks!
Ssu95bm.

Hi,

I tried this on the pc of a colleague with the problem. We looked in the windows temp directory (the only temp dir we could find). There was no Excel or VBA sub folders, and no .exd files. For good measure we emptied the temp folder to the recycle bin, but still couldn't press the button. I couldn't even edit the button in design mode on his pc! The button just sat there and did nothing.

Any ideas please ?

Thanks,
ssu95bm