Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2012, 06:21 AM
charlesmac charlesmac is offline Excel 2010 Visual Basic design/coding Windows 7 64bit Excel 2010 Visual Basic design/coding Office 2010 64bit
Novice
Excel 2010 Visual Basic design/coding
 
Join Date: Aug 2012
Posts: 7
charlesmac is on a distinguished road
Default Excel 2010 Visual Basic design/coding

I created a spreadsheet which has macros which works on every machine however on one machine when we run the macro the visual basic design/coding appears and we have to click the "play" button for the macro to run.

I have enabled VB is trusted


Macros are enabled
Ran office repair tool

But still the issues exists

Windows XP
Office Excel 2010

Any help would be nice
Reply With Quote
  #2  
Old 08-09-2012, 07:41 PM
macropod's Avatar
macropod macropod is offline Excel 2010 Visual Basic design/coding Windows 7 64bit Excel 2010 Visual Basic design/coding Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi Charlesmac,

Your profile indicates you're using Win 7, but the post refers to Win XP. Which OS is giving problems? Are all PCs using the same OS?

Please also clarify what you mean by:
Quote:
when we run the macro the visual basic design/coding appears and we have to click the "play" button for the macro to run.
What is "the visual basic design/coding"?
What is "the 'play' button"?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-10-2012, 01:13 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Excel 2010 Visual Basic design/coding Windows 7 32bit Excel 2010 Visual Basic design/coding Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

It sounds a bit like a phantom breakpoint. Do you get a messagebox saying that code execution has been interrupted?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 Visual Basic design/coding How to I make text Bold in a User Form -Visual Basic gurp99 Word VBA 11 03-12-2012 04:05 PM
Word Visual Basic error - run time error 504 crazymorton Word 11 01-13-2012 04:32 AM
Visual Basic Editor changes from 2003 to 2007 Rockitman31 Word VBA 4 09-21-2011 12:01 PM
Referencing Tables in Visual Basic Editor DavidB Word Tables 0 09-21-2009 04:01 PM
Excel 2010 Visual Basic design/coding A little Visual Basic Help Please leroytrolley Excel 4 08-22-2008 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft