open workbook on same worksheet
Can anybody advise how I can get my workbook to automaticaly default to a
certain worksheet once opened,
ie when the workbooked is opened it will always default to the 'welcome'
ps I'm a novice - so go easy
Excel opens workbooks with the same sheet active as when the workbook was
saved. The only way around that is to use a macro to switch sheets when the
workbook opens. Of course this requires that the user not disable macros.
Open the VBE and select the ThisWorkbook module. Paste this code in,
changing Sheet1 to your sheet:
Private Sub Workbook_Ope...How can I write vertically in some columns on an Excel spreadshee.
I am a teacher and take attendance on Excel spreadsheets. I want to
vertically write 'Christmas Holiday" or other wording in some columns. I
would imagine there is a way, perhaps using PowerPointm but I do not know it.
Also I have not been able to find it in 'help'. Any help out there?
Select the cell that contains the text
Select the Alignment tab
In the Orientation section, click on the Vertical text,
or drag the red diamond to rotate the text
Teacher using spreadsheets wrote:
> I am a teacher and take attendance on Excel spread...MS Outlook 2007
I am running MS Outlook 2007 on a Vista home lap top. When trying to delete
files (or folders) in the Deleted Items folder, I get a message that "the
Folder is full" and the items remain. I "right click" on Deleted Items,
select "Empty 'Deleted Items' Folder", and I get the usueal warning msg that
states "Are you sure you want to permanently delete all the items and
subfolders from the 'Deleted Items' folder?" I click on "Yes". I then get a
second warning msg that says "The folder is full."
The ite...excel #41
Can you put a list into alphabetical order using excel
Select the list -
sean <firstname.lastname@example.org> wrote in message
> Can you put a list into alphabetical order using excel
Yes you can. You need to highlight the entire worksheet and then index by the selected field that you want in alphabetical order
----- sean wrote: ----
Can you put a list into alphabetical order using excel
...Use of MS Dynamics CRM in Utility Billing
I was wondering if we can easily use Microsoft Dynamics CRM 3.0 for 'Utility
Billing System and Print Presentment'. This also involves use of handheld
devices for reading meters and bill presentment.
In case you know about a better solution for this requirement, please share
that with me.
Cell: 0060 17331 4676 | email: IfThenElseEndIf@msn.com |
That depends on what you mean by "easily" ;-)
CRM out of the box will provide a great, flexible platform to quickly
develop a robust business solution. Fro...MS Office 97 to MS Office 2007
I have been running Office 97 pro on Windows XP because I do not want
to loose the shortcut bar that came with 97.
Thing is that I have been thinking about installing the 2007 version
of Office that I have had but never installed yet for above reasons.
Question is can I install the 2007 version over the 97 version and
have it update the programs but keep the shortcut bar??
I know there are probably other shortcut bars or whatever out there
but as I asked I would rather keep the 97 one if possible.
Microsoft has several Knowledge Base articles on running multiple...Military Time in Excel
I would like to create a timetable in Excel with the format in the 24 hour
clock without the colon, which I believe is known as military time. I am
leaving the colon out for a number of reasons, aesthetic and to speed up
I wish to enter the time, for example, 8:30 am as 0800 and have Excel
interpret it as a time, as these will be graphed, so need to be interpreted
as time, and not plainly a number. At the moment Excel simply shows "800"
when I type 0800.
I have tried formatting all the cells as Custom "hhmm" instead of "hh:mm",
but when ...Difference between MS EPM and MS Projects
What is the difference between MS EPM and MS projects
Is it just project server and sharepoint added to MS projects together
called MS EPM?
Yes. EPM is Enterprise Project Management. Microsoft's solution is Project
Professional plus Project Server which in turn uses SharePoint technology.
Microsoft MVP for Project - http://www.project-systems.co.nz
Author of the only book on Project VBA, see: http://www.projectvbabook.com
"Project Mgt Noob" <Project Mgt Noob @discussions.microsoft.com> wrote in
message news:A565E3DF-A7FC-4D2A-B2F1...MS Exange connection
It deals with Outlook 2003, running under Win XP home:
A friend has two ISPs, one with standard POP and SMTP servers, no problem
The second is a remote MS Exchange server. He connects to both via Internet
using ADSL connection.
Question: how to configure the Exchange server connection such that it
remembers his ID and PW? I could not find anything under just about any
thinkable tab in Outlook, email accounts, etc.
Any help will be greatly appreciated.
...How do I do word count in MS Publisher?
Publisher doesn't have a word count; the work-around wound be manually count
the words or you could try copy the text and paste into Word.
Don - Publisher 2000�
"Mike Finn" <Mike Finn@discussions.microsoft.com> wrote in message
Why not just do a "Edit Story in Microsoft Word" instead of copy and paste?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Don Schmidt" <Don Engineer@PNB.Retired_...MS CRM Certification question
I have a question regarding the CRM certification? What, if any,
certifications are there available with MS CRM? Is there anything like CRM
Have I earned any certification if I passed the Applications Professional
Kuba Skalbania [MCAD]
...How do i access microsoft excel on windows xp? #2
I recently purchased a pc that came with windows xp home. I thought the
microsoft excel programme would come with it, but i can not find it anywhere.
Does this mean i have to purchase it seperately?
Yes; or as part of Microsoft Office.
> I recently purchased a pc that came with windows xp home. I thought the
> microsoft excel programme would come with it, but i can not find it anywhere.
> Does this mean i have to purchase it seperately?
Awhile back, there was an add-on for excel that had a lot more tools. It
showed on the toolbar. Somehow I lost it and I would like to get it back. It
had a lot of tools like for changing case and fill ins. Any help wouyld be
Maybe ASAP Utilities.
Try a 'net search for this add-in.
Gord Dibben MS Excel MVP
On Sun, 22 Mar 2009 20:22:43 -0400, "kmkx70a" <email@example.com> wrote:
>Awhile back, there was an add-on for excel that had a lot more tools. It
>showed on the toolbar. Somehow I lost it and I would like to get it back. It
>had a lot of t...How do I compare two lists of names in excel?
I am comparing 2 lists of attendances to conferences, so there are large
numbers to go through, and 1 list will have more attendees than the other.
Is there any formula I can use in excel to highlight names that appear only
in the larger of the 2 lists?
Chip Pearson has information on finding and tagging duplicate entries in
Jack the Cate wrote:
> I am comparing 2 lists of attendances to conferences, so there are large
> numbers to go through, and 1 list will have more attendees than the other.
> Is there any formul...auto file path update when excel sheet moved to another directory.
I've been working on a huge excel file for a while and I'm trying to make
it easier to use. My problem is that when it is moved from the template
folder to a working folder the formulas referencing a file in the template
folder have their path changed in the formula and have to have the links
updated. Since the file is protected it's impossible for the users to chance
the source. It's wierd because it will still pull information, but if
information is changed in the external data file the updated doesn't get
I need some like the $ command to ...MS Money 2005 Basics
I am new to MS Money after many years with Quicken. Money help
offline and online, seems woefully short of detailed explanations o
user scenarios. . Searching help for "Epay" yields nothing. Ca
someone either direct me to a better help area or answer this
In Bills what is the difference between Epay, APay, and Direct debit
I see Apay is how i use the bill pay service of my bank. Is direc
debit just my manual entry? What then is Epay? What might "Other
payment type then be used for?
The difference between them is this
Epay is for electronic bill pay. You must have Bi...Please help with Excel VB question
I'm trying to set a Name range in Excel through VB, by setting the name
property when a specific cell in a worksheet is changed. The code is as follows:
fred1 = CStr("=PL!$A$4:$E$" Worksheets("Control").Range("maxnumpass").Value)
ActiveWorkbook.Names.Add Name:="numpasslist", RefersTo:=fred1
My problem is that the change is only active for the worksheet where I change
the cell. Is it possible to ensure that this change takes effect across all
worksheets in the workbook?
Any and all help appreciated either in a reply to this post or on
jgal...Sent items downloading problem in MS office outlook 2007
In my client pc's i have configured the Microsoft office outlook
2007 after the configuration inbox mails are visible in inbox but
sent items and other folders are not getting downloaded, my mail
server is squirrel mail ,so please let me know the reason .
POP3 or IMAP?
"xpmate" <firstname.lastname@example.org> wrote in message
> Hi all,
> In my client pc's i have configured the Microsoft office outlook
> 2007 after the configuration inbox mails are visible in in...is xl worksheet multiuser
is it possible to make xl worksheet multi user for data entry, i think multiple users can open it as read only, but i want to write in it as well..
Murtaza, there are two features that you should investigate. One is Share
Workbook on the Tools menu. The other is Protect and Share Workbook under
Protection on the Tools menu. Both allow multiple users to access and modify
a workbook simultaneously. (I'm working with Excel 2003. The wording of the
commands may be different in earlier versions but I believe both features
have been in Excel since 97.)
"DDM's Microsoft Office ...MS Access
Why doesn't MS support MS Access for Macintosh? Since I work in an
educational environment that's mostly PC with MS Office begin the main
suite, it would only be logical that since the PC version of MS Office
contains MS Access for database entry, the Mac version of MS Office would
also have MS Access.
In article <BE09D66D.5FB8email@example.com>,
Red Claw <firstname.lastname@example.org> wrote:
> Why doesn't MS support MS Access for Macintosh? Since I work in an
> educational environment that's mostly PC with MS Office begin the main
> suite, it would only ...Starting MS Outlook on startup
How can I start Outlook on startup (XP) and keep it running in the back?
>How can I start Outlook on startup (XP) and keep it
running in the back?
All you need to do is move the Outlook program icon to the
startup group in XP.
>How can I start Outlook on startup (XP) and keep it
running in the back?
>Double click My Computer, go into the C:\Documents and
Place an Outlook shortcut into this folder and it will
automatically startup when...My Excel file won't close on my Mac
Hi - <br><br>I have an excel file open on my mac and i can't close it - I can't save it - I can do anything with it - all the functions on the tool bar have adopted ghost functionality. I've tried to open the file again and this message appears: <br><br>'A dialog or alert is currently open. close the dialog or alert and open the file again.' <br><br>I can't close the file though - <br><br>Any thoughts? Thanks for your help. <br><br>Cian
On 3/18/10 11:21 AM, Cian_Flood@officeformac.com ...Restarting MS Money with a "correction" switch
This is a multi-part message in MIME format.
I currently use version 10 - 2002 Deluxe, and I need to startup MS Money =
with a correction switch that I hope will correct some problems that I =
been having, but I can't seem to locate the post that talks about doing =
this. Is it "msmoney.exe /s"?
(if replying, replace nospam with rpottharst)
c...excel if, then...problem
Is it possible to have a cell's color changed depending on another cells
We keep track of shipments coming in that are 1) either for customers
or "STOCK" 2) a certain amount of cubic footage.
This is what I'm inquiring...
Let's say that the cubic footage is anything over 20 could the
corresponding cell with the "Company's name" be changed to blue
And, if the customer is anything other than "STOCK" could it be changed
Attached is a copy of the form that we use....however we color the
cells ourselves. I'm jus...Excel 2007 - VBA
How can I set the xaxis to an arbitrary angle, say -70 deg using vba?
I recorded a macro to do this and it does not actually do anything??? Tried
it 3 times. I end up with the proper layout but the recorded macro does not
actually format the xaxis when run again?!
.Alignment = xlCenter
.Offset = 100
.ReadingOrder = xlContext
.Orientation = -70
On 24/02/2010 15:32, QB wrote:
> How can I set the xaxis to an arbitrary angle, say -70 deg usi...