How to keep the macro running?
Is it possible to include a code to let the macro to run non stop? i
yes, would excel crash if i activate another macro at the same time?
Message posted from http://www.ExcelForum.com
Only one macro can run at a time. If a macro is running, you can't do
anything else with XL.
Take a look at the OnTime function to have a macro repeat at fixed (or
variable) time intervals:
In article <email@example.com>,
hce <<firstname.lastname@example.org>> wrote:
> Hi All
> Is it possible t...i cannot view documents in vista from an external hard drive
I can't open anything that I saved onto an external hard drive now that I
have the Vista system prior to this I had XP
On Sat, 12 Jan 2008 18:38:00 -0800, Whizz
Wrong news group. This one is about Microsoft Access, the database
>I can't open anything that I saved onto an external hard drive now that I
>have the Vista system prior to this I had XP
I am sure that this question has been asked and answered. I am creating a
worksheet for my class. I have a value in cell b2( I want use this value
thru out the sheet). Let say b2 = 10
b c d
3 5 6 8
4 3 7 1
I want to subtract each value from b2(10). How can I do this without doing
On Thu, 1 Apr 2010 14:06:04 -0700, AFL-math
>I am sure that this question has been asked and answered. I am creating a
>worksheet for my class. I have a value in cell b2( I want use...Keeping photos in line
Several questions about moving photos in columns:
I have a two column page, a manuscript of 150 pages, and want photos t
slide with the type as I insert text in previous pages. I use th
format, inline, move with copy instruction. Sometimes it moves th
photo over to the other column.
I want all photos inserted from files to automatically be embedded, o
inline. Is there a command for that?
Is there a better way to do a caption for the photos, what we printer
call a cutline, than use a new text box? I have to in line it too, an
it sometimes wants to move one or two lines when I give the order...How do I keep my own formatting for a pivot-chart on refreshing
I have many pivotcharts which need to be continually refreshed to represent
statistics from data within the workbook. I need to display these charts with
my own colour scheme - however the charts are refreshed they revert back to
the dodgy Excel default colours.
To complicate matters further they are part of a shared workbook - so my
macro I recorded to re-apply my colour scheme doesn't work.
Can anyone help????
...OneNote 2010 RTM not allowing "share to web"
I am trying to create a notebook in OneNote 2010 RTM and use the "share to
web" option but it says "This service is not available." Is there something I
have to do to make this available?
Just be patient. That feature is waiting on the Live.com guys to get their
stuff checked in and rolled out. I don't know their schedule but it could
happen at any time - I think they're pretty close to ready.
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's G...How do I hide zero values but keep currency format in P.O. form?
I'm creating a purchase order for our company and am having trouble
formatting some cells. I need a currency value in the Total section only if
there is a value in the Quantity and Unit Price section. I formatted the
Total cells to Currency. But if there are no values in Quantity or Unit
Price, zero values appear in the Total cells. How do I format the total cells
to only show price values when there are values in Quantity and Unit Price?
When you format a cell as currency you get a custom format like this
(depending on the otpions you chose)...
Choose the ...new hard drive #3
how do i find my contacts or address from my old hard drive ?
"emc2" <email@example.com> wrote in message
> how do i find my contacts or address from my old hard drive ?
Search for a file called *.pst
emc2 <firstname.lastname@example.org> wrote:
> how do i find my contacts or address from my old hard drive ?
can't find it.......
"Brian Tillman" <email@example.com> wrote in message
> emc2 ...Combining Worksheets and keeping them separate
I have a workbook that contains two worksheets.
Worksheet one as information such as name, address, etc.
Worksheet two has the same fields/columns of information, however the data
itself is different.
I need to keep these two lists separated, however, I also need to have them
combined at times.
Is it possible to create "Worksheet 3" that will automatically update when I
add/modify records in Worksheet 1 or Worksheet 2?
There is not an easy way to do that.
Instead of three worksheets, use one worksheet (a single database). Then
you have two choices.
1) Enter...Contacts 'display as' keeps showing email address even when I dele
I'm using Outlook 2007 recently upgraded from Outlook 2003 contacts.
I don't like email addresses showing in emails, so I have always written
'display as' with name only in Contacts. However, Outlook 2007 has added the
email address in 'display as' for everyone. When I go in to delete the email
address, SAVE and Close - and go back to check, nine times out of ten, the
email address is back in there. Very frustrating.
Is this a known problem? Is there a fix? I just want 'display as' to
simply reflect what I put in there - not what Outlook decides...Money2004 keep crashing on startup
just install in my WinXP SP1, which has IE6.0 SP1 installed already.
Money2004 Std keep crashing on startup after install.
with error dialog of "restart Money - Send / don't send report"
any idea ?
Any further details in the error, such as whether it's an Invalid Page Fault
or a module name?
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email firstname.lastname@example.org especi...Disk keeps filling up
My Exchange server (Version 5.5) has a directory (Folder)... That keeps
filling up with files and making my disk full. The folder name is:
I can't for the life of me figure out why... Can anyone help me?
Thanks in advance
CCNA, MCSE, CNE
On Fri, 12 Aug 2005 09:50:24 -0400, "Dale" <email@example.com>
>My Exchange server (Version 5.5) has a directory (Folder)... That keeps
>filling up with files and making my disk f...personal folders keep disappearing
This is the setup. When we create a personal folder and point the location
of the pst file to the users my documents, which is really a redirected
network location everything is great until the pc is rebooted.
After a reboot their are no personal folders showing and users have to add a
new personal folder and browse to their my documents to locate the pst file.
The outlook profile was automatically created by running a script that
pointed to an edited .prf file.
Here is an extract from the prf file that may be the problem:
M...keeping parts of a formula same
I need to ask a simple question which involves when
draging the formula to the cells below to make copies.
If I had a Fromula like say
and I want to drag it to a couple of cells below making
copies and saving my self some time. How to I prevent one
part of the formula from changing. Because when I drag in
down to the other cells I only want *B5 to change to
*B6,*B7,*B8,*B9 etc. etc. so is there any way to do this?
Put $ in front of any references you want to keep the same ie
You can also use this to keep partial refs constant eg $A1 whic...can only see local machine users when trying to add users allowed for remote desktop access
I have a windows 2003 server on my network(its actually a virtual machine
running on windows server 2008), that I have enabled remote access to (via
properties of 'My Pc/Remote')
In the permission of the remote user tab, I can not find any domain users,
if I try to change location it only allows me to see the local machine, and
if i enter manually the domain\user name it always rejects it.
I can see the entire network when I browse the network from file explorer
and I can access shares on remotes machines with no problem, so I am on the
network and authenticat...prevent attach local printers via remote desktop
anyone know of a way to prevent users from attaching local printers
when connecting to servers via remote desktop?
may be a group policy or security policy setting?
That is done by the Client on the Client-side in the RDP utility under the
Resourses Tab (before making the connection).
Just "uncheck" the box by Printers.
The views expressed, are my own and not those of my employer, or Microsoft,
or anyone else associated with me, including my cats.
"techstress" <foscsamuel...keeping font the same size
Every time I close a visio drawing and reopen it later to make updates, the
font size keeps going from 12 back to 8 and it is annoying to keep changing.
How can I keep it that the font stays at 12 when I re-open the drawing. I'd
also like to do the same with the line weights.
Visio 2003 is installed with latest updates. It is part of the office 2003
I've got lots of Macros on my Excel from Office 97. Now, I'm upgrading
my computer and office suite to Office 2003. I have tons of macros that
I use all the time. How can I export them to my new Excel?
Thanks for the help.
Don't know where your macro's are but, in my case, I record my macro's
in a special workbook that I keep in the startup folder.
When I went to Of2k I just copied the workbook to the startup folder on
the new machine.
Maybe something's different in Off2003(?).
------------------------------------------------------------------------...keep or not keep SMTP log files?
I'm curious about what do you do with your SMTP lof files? How long do you
keep your smtp lof files? Save them onto a tape media or external harddrive?
Do you delete them after 6 months? Or don't keep them at all? I'm trying to
get a general idea what administrators do to their smtp log files. Thanks
and appreciate it.
On Wed, 25 Oct 2006 13:01:04 -0700, Ricky T
>I'm curious about what do you do with your SMTP lof files? How long do you
>keep your smtp lof files? Save them onto a tape medi...Hard drive disaster
I'm hoping someone can advise me on the following. Recently my hard drive
crashed (beyond repair and unrecoverable) days after I'd finally downloaded
windows and had spent a lot of time with applications and browsers.
Organising system settings and updates etc to get my computer just how I
wanted it. (Btw the crash had nothing to do with Windows!)
I had everything operating beautifully, and then disaster struck. Is there a
way that I can store all my systems and settings so that if my hard drive
crashes I can copy over all my existing settings, emails, book marks,
app...how do I keep comments with cell?
I want the comments that I post to stay in the same format and with the same
relationship to the cell that I post it in. Now,when I edit an existing file
with comments, the existing comments float all over the file. I would also
like to be able to reset the existing comments back to their original format.
Code from Debra Dalgleish.......
Reset Comments to Original Position
If comments have moved out of position, you can reset them using the following
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.L...5 man can work simultaneous on a Sheet saved on a local server?
We are 5 people willing to work: edit/save simultaneous (if possible) on a
Excel sheet saved on a local server.
Any suggestion welcomed!
Thanks a lot and compile succesfully!
Share the workbook to make use of the multiple users to get connected.
Press Alt+T+B and now Share Workbook Dialog box will appear and under the
Edit Tab>>Check the ‘Allow changes by more than one user at the same time’
checkbox and give Ok.
Remember to Click Yes, if this post helps!
"Dan Tabla" wrote:
> We are ...SATA Drives: Why Only UDMA 5 And Not 6?
My Computer | Manage | Device Manager | (view by type) | IDE
ATA/ATAPI controllers | Secondary IDE Channel | Properties |
Advanced Settings | Device 0
In the PC in question, this is a Western Digital Caviar Green
On this one and all the others, "Current Transfer Mode" is "Ultra
DMA Mode 5", which I understand tb only 100 mbps - whereas 6 is
OTOH, the "System" drive is a plain old IDE drive (Western
Digital WD3200AAJB-00J3A0) hooked into the board's IDE connector
and it is set to UDMA 6 - or 133 mbps.
Can anybody elucidate?
Good Morning All,
Am new to one note and have a problem. I was in Outlook Calendar and
pressed the Meeting Notes button to send the appointment to OneNote.
when I went to OneNote, I clicked the Unfiled Notes button at the bottom
left and found the page entry for my meeting. I wasn't paying attention and
instead of moving the page on the left to the tab in the notebook I wanted, I
moved the entire Unfiled Notes Tab to the notebook.
Now, whenever I send a meeting notice etc from Outlook, it goes to that
Since I have many notebooks, I want the unfiled notes t...keeping aspect ratio when changing page size
I was wondering is their a way to lock the aspect ratio on all items when
you change the page size?
Bruce Leavitt wrote:
> I was wondering is their a way to lock the aspect ratio on all items
> when you change the page size?
> thanks bruce
Including text boxes? No.
You could save the project as a picture
and insert the picture on a new page.
John Inzer MS-MVP
Digital Media Experience
This is not tech support
I am a volunteer
Solutions that work for
me may not work for you
Proceed at you...