Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default VB Window automatically displays

I have a number of macros used in various cost centers. Most of these
require the user to push a button and the end user never sees anything.

I have one user, that no matter which macro he uses, as soon as he pushes
the button, the MS visual basic window is automatically displayed.

Is there a setting that is set differently for this user than the others.
Any suggestions as to what is causing this?

Thanks for the help.....

--
JT
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default VB Window automatically displays

An untrapped error perhaps causing the code to break. Or a wild guess - are
you using application.Goto with a defined name same as some vba procedure
name. .

Regards,
Peter T

"JT" wrote in message
...
I have a number of macros used in various cost centers. Most of these
require the user to push a button and the end user never sees anything.

I have one user, that no matter which macro he uses, as soon as he pushes
the button, the MS visual basic window is automatically displayed.

Is there a setting that is set differently for this user than the others.
Any suggestions as to what is causing this?

Thanks for the help.....

--
JT



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel workbook window won't stretch across multiple displays macevhicz Excel Discussion (Misc queries) 1 April 9th 07 01:24 PM
How do I make a pop-up window that displays a range in Excel?? tyler.speer Excel Worksheet Functions 1 January 19th 07 01:22 AM
VB automatically displays JT Excel Programming 0 July 31st 06 08:50 PM
Formula window displays correct answer while cell displays incorre MMV Excel Worksheet Functions 3 November 10th 04 09:28 PM
"Immediate Window" displays strange code! Jay Northrop Excel Programming 4 October 17th 04 11:44 PM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"