Hide code execution
I am trying to find out a way to hide the procedures a
macro goes through. In other words, I want the macro to
run without the user seeing the screen flicker and jump
from cell to cell.
> I want the macro to
> run without the user seeing the screen flicker and jump
> from cell to cell.
at the beginning and add
at the end of your macro.
Jan Karel Pieterse
Try typing the following at the start of the macro
application.screenupdating = false
>-...why does my code loop?
I have the following code that's meant to calculate average times
between open and close dates. But for some reason that I can't figure
out its looping where I don't expect it to loop. I've added MsgBoxes
throughout to try to help but I'm stuck. Does anyone know why this
appears to be looping outside of the for loop?
Function LagAverage(OpenDates As Range, PNum As Range) As Single
MsgBox "starting now"
EOPeriod = Sheets("Hub").Range("B8").Value - 1 + PNum * 28
TimeSum = 0
Counter = 0
For Each ODate In ...Conditional Footer Code
I have a text box (Text586) in the Detail Section that is based upon a
dlookup command and shows either a 1 or 0. I would like the text box in the
Report Footer (txt589) to be visible if the value count of Text586 >0. This
report can be run with different parameters that could show the detail
section as one record or 20 records. My code works just only when there is
one record in the report.
If Me.Text586 > 0 Then
Me.Text589.Visible = True
You use DLookup() or DCount() or just count() or something in the report
I generally conside...Help with code #2
What I am trying to do is have a macro lookup cell b1 from sheets21 to
sheet120 and when it finds the first sheet that this cell is blank to
execute a macro.
I used to use the code below but it is way to long over this many sheets.
If Sheet21.Range("AV3") = "" Then
If Sheet22.Range("AV3") = "" Then
If Sheet23.Range("AV3") = "" Then
You can do the following, although it has a problem that I'll describe:
dim s as worksheet
for each s in ...Is there code to toggle "show column headers and row headers"
Normally, to do this manually, it's
Tools --> Options ---> 'View tab' and then you click on the
Can this be done using a macro?
Undoubtedly it can, but this forum is for Word not Excel.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<&g...faq mfc use c# code
I find a very nice control , and it was wraped in the dll use c#. How can
I use it in my application based on mfc?
Thank you all.
> I find a very nice control , and it was wraped in the dll use c#. How can
> I use it in my application based on mfc?
> Thank you all.
You will need to make your application managed along with supporting
MFC. That means using CLI if your using VS2005 or MC++ if you are using
VS2003. If you are using vc6, you will not be able to consume that
control. Essentially you are now converting your unmanged MFC app to a
managed...How can I make this code work?
Hide rows 32:33 if E30 is NO. Hide rows 36:38 if E35 is "NO"...etc. I
intend to have about 4 or 5 of these variables.
The code I have below is currently not working. code is currently
placed in the workbook. Please help! Thanks!
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Select Case Target.Address
If Target.Address <> "$E$30" Then Exit Sub
Rows.Hidden = False
If UCase(Target) = "NO" Then Rows("32:33").Hidden = True
If Target.Address <> "$...MultiLine Code Builder, Need Help to Clean Code:
My end goal is to create multi-line code that I can paste into VBE.
Currently I'm pasting code like this...
If Worksheets("vessel").Cells(CurVesl,8).Value Then
frmVesselLog.DTPICKER1.value = Worksheets("vessel").Cells(CurVesl,11).Value
For example Column D is:If Worksheets("vessel").Cells(CurVesl,8).Value Then
Column E is : Else
Column F is: frmVesselLog.DTPICKER1.value =
Column G: End IF
Column H is
row1 If Worksheets("vessel").Cells(CurVesl,8).Value Then
row2 E...Code number
When using drop down boxes under the Data:Validation menu,
is there a way of having 2 columns; one that has a
description and one that has a code number ? So you are
prompted by the description but only the code number ends
up in the cell
You could use a formula that returns the number based on the description chosen.
If your descriptions/numbers were in Sheet2!$a$1:$b$99, you could use this
=if(a1="","Please select your choice",vlookup(a1,sheet2!$a$1:$b$99,2,false))
Then use that cell with the codes in them in other formulas????
> ...Adding macro code to Personal Macro Workbook
I have a .bas file and would like to insert this code
directly into my personal macro workbook. However, I
can't find a way to DIRECTLY insert the code. The only
thing close is to record a dummy macro, then step into
that macro and insert the *.bas code that I really want.
Can someone tell me of a better way to do this?
I'd just open the .bas in notepad and copy|paste to my favorite module.
but if you right click on the project (when you're in the VBE), there's an
"Import File" option that may work the way you want.
> Gree...usb host controller error code 43
On my Windows 7 laptop at home, I'm getting usb host controller error code
43. My usb printer works and my usb flash drive works but my external 250gb
usb drive does not work. Any ideas on how to fix this?
BY the way why is there no newsgroup for Windows 7 at
"mcp111" <email@example.com> wrote in message
> On my Windows 7 laptop at home, I'm getting usb host controller error code
> 43. My usb printer works and my usb flash drive works but my exte...Hiding macro code
I'm sure there's a simple way to do this but I've not
been able to find it. I can hide/protect Excel
sheets/formulas, etc. but how do you prevent users
accessing the VB Editor and seeing your macro code? I
don't have digital signatures, etc and I want users to be
able to run the macros without hassle, just not visualize
In the VB Editor:
Tools/VBAProject Properties/Protection/Lock for editing (and add password)
This is NOT secure, by the way. Crackers for these passwords are ten a
A more secure way would be to...VB 6.0 to Access 2000 code conversion
i'm trying to convert my Visual Basic 6.0 code, forms,
etc. to an Access 2000 database. Is there a automatic
converter ? Anyone knows ?
Not really. Tony Toews lists some products that purport to be able to do
this at http://www.granite.ab.ca/access/accesstovb.htm but the general
consensus is that they do an incomplete job at best.
There are simply too many differences in the controls available for VB forms
vs. those available for Access forms. In general, you're going to be better
off recreating the forms manually. (You can, of course, simply
copy-and-paste ...Task Manager Matlab error XP PRO SP3
I have scheduled some Matlab Jobs on Windows Task Manager.
Sometimes this job doesn't start (without return any error) and i have to
start them manually.
I'm using Windows XP PRO SP3.
How can i resolve this error?
Thanks in advance
> I have scheduled some Matlab Jobs on Windows Task Manager.
> Sometimes this job doesn't start (without return any error) and i have to
> start them manually.
> I'm using Windows XP PRO SP3.
> How can i resolve this error?
...Bar Code Readers for POS
A client is interested in bar code readers for use with the Compass point of
sale application. They have six registers. They are primarily interested in
guns as opposed to wands.
Does anybody have experience with bar code readers in a POS environment?
Charles you can contact www.tstek.com for this.
"Charles Allen" wrote:
> A client is interested in bar code readers for use with the Compass point of
> sale application. They have six registers. They are primarily interested in
> guns as opposed to wands.
> Does anybody have experience with bar...Error code 0x800CCC00F
Occasionally when sending or receiving email, I get a
message that displays the following error and says "the
server responed '+ok' or '?k'"
I looked this issue up on the Knowledge Base and they say
that the problem lies with Norton Antivirus 2003. The
best solution that either company can come up with,
however, is to turn off e-mail virus protection. And here
I thought that Microsoft was committed to security.
Has anyone dealt with this problem, and if so, have the
come up with a less idiotic solution than the one in the
...code to hide a worksheet?
Can VBA code be written to hide a worksheet? I can't seem to find any
help in the help about this...
Thank you much,
Yes, you can change the Visible property of the Worksheet object:
Worksheets("Sheet1").Visible = xlVeryHidden
Worksheets("Sheet1").Visible = xlHidden
xlVeryHidden will hide the sheet so that it may not be unhidden via Format |
Sheet from Excel. xlHidden will hide it just as if you had hidden it via
Format | Sheet --> Hide.
MS MVP - Excel
[please keep replies in t...forms, tables, codes, and their relations --HELP!
i'm developping a database to help advise students at university and keep
track of their progress.
in the table, i have each row committed to a particular student, with their
requiremens in the columns. each requirement has a drop-down box with codes
in it. each code has a particularl meaning. i want to save the codes in the
table. the code AB means "not yet completed" (and yes, i do have a table of
HOWEVER, on the form associated with this, i also have dropdown boxes, but
in them, i want the meaning of the code to appear, but not the code.
Here's the p...COM communicate with managed code(.NET)
When I have a communication from COM to managed code(.NET) a type
library(TLB) is necessary in between to handle the communication from COM to
I tried to use Red Gats's reflector to look into the type library that have
extension tlb but it's not possible.
So why is it not possible ?
"Tony Johansson" <firstname.lastname@example.org> wrote in message
> I tried to use Red Gats's reflector to look into the type library that
> have extension tlb but it's not possible.
...Money 02 standard/wages&salary:net not shown in reg income
When preparing my budget in money 2002 standard v10, I
entered my monthly income under Regular Income. Since
then I've added a sub category under Reg Income (wages
and salary: Net) and customized all of my monthly income
there. Now money only shows the intitial income amount
which is incorrect and says my budget does not balance.
How can I edit the regular income to sow the correct
...Changing case in code
I've added a line of code to the event below that will uppercase the data in
the last-edited cell but the update takes a few seconds on my PC (probably
longer on the production pc it will eventually run on). Is there a way i can
better place the Ucase code? I've tried, unsuccessfully, to move it outside
the For/Next loop. I won't pretend to understand the Set statement.
Any help would be gratefully appreciated
Private Sub Worksheet_Change(ByVal Target As Range)
'David McRitchie, 2000-08-08 rev. 2000-08-14
...matlab and power point
Good morning all!
I have created a graph in MATLAB and want to use that as a background for my
Powerpoint slides. Could someone please tell me how that is done. Any help
wil be sincerely appreciated.
This is the wrong group..
why don't you google it? :)
"RM" <RM@discussions.microsoft.com> wrote in message
> Good morning all!
> I have created a graph in MATLAB and want to use that as a background for
> Powerpoint slides. Could someone please tell me how that is done. Any help
> wil be since...Reverse C++ to UML
When reversing a C++ project into Visio from Visual
Studio 2003, the class diagram has NO associations
between classes, except for inheritance.
Is this all that I can expect or is there something else
I should do to get association links displayed?
Associations are not reverse-engineered.
Only inheritance and interface realization links are shown.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nigel Aston" <email@example.com> wrote in message
> When reversin...Suppress warning when Merging Cells by Code
While writing in Excel through Code I have also merged the cells.
_objRange = _objWorkSheet.Range(_objWorkSheet.Cells(_intCurrentRow,
17), _objWorkSheet.Cells(_intCurrentRow, 18))
_objRange.Value = intTotalTax
But, when I merge the cells from code then too a warning is shown to user on
UI $B!H(BMerging Cell will keep only contents of top left cell$B!I(B.
How can I suppress these warnings?
This is happening in Excel 2000 (10.0 Object Library) on WindowsXP.
Thanks and Regards,
_objWorkSheet...Simple MFC/C++ development question
I want to develop a simple GUI utiliy using C++/MFC.
I mostly develop for Linux using Java/C and I am used to
used Sun's JDK and GNU's C compiler running under Linux.
My question is where can I get a minimum set tools I need
to develop a MFC application. I don't really want an IDE
(i.e. VC++6) - what I'm after is a compiler and the
header/libraries to link my MFC based utility against. I
will use my favourite editor to enter the code.
> I want to develop a simple GUI utiliy using C++/MFC.
> I mostly d...