Rename Sheet Event
When we rename a sheet Excel crashes. What event is triggered when a sheet
Thanks in advance
No events are fired. I tested the change, right_click, double_click.
What are you trying to name it? History and *!/?\ are barred characters
Try unchecking any add-ins... (Tools>add-ins...)
Try moving you Excel.xlb file out of it's current location and see if that
sorts it. (Remember to close and re-open Excel each time you do something)
Lastly, try detect and repair under the help menu
Microsoft MVP - Excel
nic...SAVING PART OF SHEET
I have a workbook that has 5 sheets. I print off a section of sheet 1 and
ideally this is the only part of the sheet I want saved in my archives . Any
idea how I could set my workbook up so that I can save just a part of the
sheet or even only sheet 1 of the workbook?
You can't save part of a workbook.
You can however, copy the sheet or part of it to a new workbook and save that
Copy the sheet or part of sheet from original workbook to new workbook.
Gord Dibben Excel MVP
On Sun, 4 Jan 2004 12:37:58 +1300, "gregork"...2004 trial, how do I get rid of it?
My trial is over, and I want my Money 2002 back. Does
anyone know how I can do that?
The easiest way is to use control panel->add/remove programs to remove the
2004 trial pieces (there are two programs to uninstall). Then reinstall 2002
and use the backup file created when you first installed Money 2004 - it'll
be named something like My Money.M10. Any transactions entered in the trial
which you want to keep will need to be re-entered into the 2002 version, as
you can't downgrade a file from 2004 to 2002.
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.co...Sequential ticket numbers and printing 4 to a page
i have mail merged my numbers from excel into my publisher ticket. Thanks
that worked well, now i want to print 4 tickets to an A4 page and in print
preview, i get 4 tickets all with the same number on one page. how do i get
Print preview showing all the same is a bug. Print a test page.
Mary Sauer MSFT MVP
"Neyol" <Neyol@discussions.microsoft.com> wrote in message
news:90034D4C-9951-4550-9DAC...Where to get missing msvcp70.dll?
After I uninstalled a bunch of software, when I run an app it says app
failed because msvcp70.dll was not found.
Re-installing that app does not help. I guess I need to restore the missing
msvcp70.dll. What is the official way to get it?
Some sites offer this file for download but I'm not sure the files are
In my system32 folder there is msvcp50.dll, msvcp60.dll, msvcp71.dll, but no
msvcp70.dll. It is not in the recycle bin either :(
"james" <email@example.com> wrote in message
> After I un...get rid of macro option at startup
I created and then deleted a macro in an Excel file.
Why do I still get the warning box (i.e. the one asking if I want to enable
or disable macros) when I open the file?
Is there a way to get rid of this since I no longer have macros in this
You need to delete the empty module.!
"Brad Rench" <firstname.lastname@example.org> wrote in message
> I created and then deleted a macro in an Excel file.
> Why do I still get the warning box (i.e. the one asking if I want to
> or disable macros) when I o...AOL IMAP account
I have set up AOL email account as IMAP type and keep getting pop up in outlook " your IMAP server wants to alert you the following: Can't read attachment for message 6438.
this pops up for many times and each time the number is different.
new profile same issue.
Office Version:Office 2007
Operating System:Windows Vista / Windows 7 - same issue.
Submitted using http://www.outlookforums.com
Do you have a virus scanner installed which integrates itself with Outlook?
Uninstall this integration part of your virus scanner and try again; you'd
still be sufficiently p...Menu Page
I'd like to make a menu page with buttons to jump between spreadsheets
of a workbook. I will turn off the tabs at the bottom in order to do
this, but I'm looking for code for my menu buttons to flip to each
Also to return to the menu from a specific spreadsheet, I'd like to use
a right click to jump back to the menu. Can someone help me with this.
I'm used to programming in MS Access, so programming in MS Excel is a
new venture for me.
How about an alternative...
Create that index worksheet and put hyperlinks to A1 of each sheet.
And then put a hyp...Exchange 2003 SP1 to get DST patch & Exchange 2000 patch is available to anyone for $4,000
This is a multi-part message in MIME format.
In the "New Highlights" section: "Exchange Server 2003 SP1 will now be =
supported for an updated version of the Exchange CDO patch to be =
"DST Hotfixes for products in Extended Support can now be purchased for =
...Detect page change in PropertySheet?
Hi, I have a property sheet that is the parent of several property pages. If
the user clicks a tab to change to another page, is there a way I can detect
this (and possibly prevent the change) in the PropertySheet dialog? Does
windows/MFC send any kind of message to the PropertySheet dialog?
I looked at all of the over-rides and WM_ message, but cannot see anything.
Not directly. You can catch that in the CPropertyPage and relay the message
to the CPropertySheet. (I know you are asking, why doesn't the
CPropertySheet get the notificatio first? who knows!)
"...Force a page break in code
I need to force a page break in the Detail_OnFormat
Event when a value changes. How do I do that?
> I need to force a page break in the Detail_OnFormat
> Event when a value changes. How do I do that?
Insert a PageBreak control from the ToolBox bar at the desired location. Even
though such a control is never "visible" other than in design view they do still
have a Visible property. That property effectively turns on and off the
PageBreak so you can minipulate that in your code.
Rick Brandt, Microsoft Access MVP...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <email@example.com> wrote in message
> How to get only the year in the date form...View as web page in OWA
in OWA 2002, i remember there is a feature "View as web page" on the right
side of the email.
in OWA 2003, after open the received email, such feature no longer there.
Anyway to enable this feature?
...Creating a print-macro that'll only print page 1?
I have a spreadsheet that contains multiple sheets. I want to add a
button that runs a macro, which only prints page 1 on the first sheet
The "Scorekort" sheet contains 13 pages in total, but I only want to
print the first page.
Any ideas for this macro?
Sheets("Scorekort").PrintOut From:=1, To:=1, Copies:=1, Preview:=True, Collate:=True
if you don't want a print preview, Preview:=False
Le 2011-05-21 04:16, Anders M a �crit :
> I have a spreadsheet that contains multiple ...Page break preview & blue line
I using Excel 2003
In page break preview I have always do some thing wrong I'm just pull the
blue line by using mouse all page was destroyed
It there any tips to return the blue line to the Default pages size setting
As far as I know the 'default' print area is all the data, and once you have
changed the print area and saved the file you can not get it to go back to
the previous setting.
If you have problems with this or any other proceedure do try to remember to
save your file before you do the awkward bit and then you can go back to the
saved copy it it does not work.
...How do I print only odd pages in Publisher and then only even page
I am attempting duplex printing with a printer that is unable to do duplex
printing by printing odd pages first and then flipping the pages over and
printing only even pages.
No option is given that I can find in the print window.
Sarah Wright wrote:
> I am attempting duplex printing with a printer that is unable to do
> duplex printing by printing odd pages first and then flipping the
> pages over and printing only even pages.
> No option is given that I can find in the print window.
The duplex printing add-in can be found here
(http://publisherm...M2004 Won't Save Customized Toolbars / Home Page
Unable to find anything in archives or the UFAQ on this...
My Money 2004 file recently stopped saving customized toolbars / home
page. Any changes I make don't "stick".
I've used super salvage, which supposedly found and corrected some
errors, but the problem persists.
Try this (and it is in the UFAQ under a less specific topic at
http://umpmfaq.info/faqdb.php?q=153). Stop Money Express. Change your
toolbar stuff. Exit Money. Restart Money. Restart Money Express.
"Sock" <firstname.lastname@example.org> wrote in message
news:8205f05b.04101407...Getting kicked of outlook2003
Every time I print directly after I get kicked offline
Do you mean that Outlook closes?
"jp614" <email@example.com> wrote in message
> Every time I print directly after I get kicked offline
No, It completely boots me off the network. When I loose connection to
Outlook it takes my computer offline--looses connection...
"Vince Averello [MVP-Outlook]" wrote:
> Do you mean that Outlook closes?
> "jp614" <firstname.lastname@example.org> wrote in message
> ...Add a blank page separator
How do I add a blank page automatically as a separator after every 15 pages
when printing a document of 250 pages?
Use a macro containing the following code to print the document:
Dim i As Long
Dim blank As Document
For i = 1 To 240 Step 15
ActiveDocument.PrintOut Range:=wdPrintFromTo, From:=i, To:=i + 15
Set blank = Documents.Add
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professio...Formatting cells and getting pound signs
I am using Excel 2003 with all updates as of 4/28/04 and trying to format a cell using the custom category and choosing the #,##0.00 type.
I am trying to add the $ symbol at the beginning of the type and add text at the end of the type to look like this $#,##0.00 "text".
When I do this however it shows up in my cell on my worksheet as ##########. It does know what the value is and shows as I would expect it to when I place mouse over cell in a balloon
If I use only the $ symbol befor the type it shows fine. If I use only the "text" after the type is shows fine. Using the...Adding a button with a function on protected sheets.
How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).
Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the
files is saved, I need to clear that data for use on the next day.
How is this Reset button applied with allowable edit ranges, VLookup data
and a protected worksheet?
There's several ways to do this.
1. Instead of straight vlookups, use
=IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) wher...get rid of extra spaces between paragraphs worked only once.
Changed style from Word 7 to Word 3, used help online, but still have 2 left
with spaces I cannot get rid of on my last page. Got any help for me?
Only fools and bigots prefer French over Spanish to be taught in public or
In the Styles pane (Ctrl+Alt+Shift+S), right-click the style name and choose
Modify from the context menu. In the Modify Style dialog box, click Format,
Paragraph. Make sure that Line Spacing is what you want, and that Spacing
Before and Spacing After are both set to zero. Click OK. To transfer the
style definition to the attached template, d...How do I set up mixed page orientations in Publisher 2003?
I'm trying to create a duplex publication where one side is in portrait and
the reverse is in landscape. I've tried looking in the halp and through all
the menus but it seems that I can only have one or the other. Can anybody
Publisher (any version) does not support this. The workaround most
frequently offered is to design your landscape page, group the all the
objects, then rotate 90 degrees.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"T. Mitchell"...Get firefox- The fastest web browser in the world!
FireFox is a web browser created by Mozilla,it's the fatest web
browser in whole world
download now from site:
> FireFox is a web browser created by Mozilla,it's the fatest web
> browser in whole world
> download now from site:
If you don't mind it's memory leaks. If you re-boot each day it may not
be a problem for you.
...Data from multiple sheets and workbooks
Each week I receive a workbook from one of my customers. It contains mutliple
sheets with salesnumbers from all the branch of my customer. Each sheet
contains from 1 000 to 15 000 lines of salesdata. Every article sold gets one
line in the sheets.
Each workbook are named "weeknr.xls" and are stored in the same folder.
Now my question/problem. I need to gather all sales info for one branch on
one article from all the weeks.
I know how to get the data from one workbook to another, but how do I get it
to scan all the workbooks in the folder.