Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro runs twice but just on my machine

Status
Not open for further replies.
Feb 29, 2012
26
GB
Hi

Not sure what as happened. We have some macros that we run in Excel 2010 and usually all work ok.

For some reason on my machine only, the macro runs twice (asking same prompts). When other people on their machines run the spreadsheets (the macros are Auto open) they run ok and only once.

can anyone point me in the right direction how to solve this. I have looked a thousand times at my Excel settings but cannot find anything.

Any ideas please.

Thanks
 
hi,

Try disableing your Add-Ins one at a time and go about opening the workbook of interest. That's the sort of thing that you do to debug problems.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Hi

How do you disable them, I can fnd the Add Ins but nothing to dasable them.

Thanks
 
You activate tha Add-ins window and UNCHECK an Add-in.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Hi Skip

Ok great we found the culprit and it is now working. In this case it was a sage reporting add in, but worth knowing about this.

Many thanks for your help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top