Lock and Unlock multiple tabs at once
How can I lock and unlock multiple tabs at once. This workbook contains 100
tabs. I will be nice to lock and unlock all the tabs at once without having
to go thru the tabs individually
ab., you can use a macro like this
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
"ab" <email@example.com> wrote in message
> How can I lock and unlock multiple tabs at once. This workbook contains
> 100 tabs. I will be nice to lock and u...COUNTIF Multiple Conditions
How do I use countif with multiple conditions
Column B has dates
Column C has Various data or Blank
I need to count the number of non blanks in column C if column A is one
of 3 dates
I have tried the array formula below, but am getting the wrong answer
A6, A7 and A8 are the cells witth the dates in
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getin...UDF on query
How to create any user define function that can be called from query
like Ms Access standart function? If possible give one simple
If you have a function (has to be in a module) that get a parameter and
return a value, you can call this function from the query just as you use a
build in function in Access
Function FunctionName(MyNumber as Double)
FunctionName = MyNumber * 100
Select TableNAme.*, FunctionName([FieldNameToPass]) As NewFieldName From
> How to create any user define fun...Tutorial On Using Windows Vista Compressed Files Capabilities
Where can I find a link or tutorial on using Windows Vista's Compressed Files
Capabilities? I am of need to create several Zipped Compressed Files. I am
not interested in third party software. Thank you Eddy.
Very simple - Right click the file ( or Files ) and from the context menu
place your pointer over "Send To". From the secondary menu choose
"Compressed (Zipped) File".
"Eddy" <Eddy@discussions.microsoft.com> wrote in message
> Where can I find a link or tutorial on usi...Search multiple IMAP Foulder
I have various IMAP Accounts in WLM.
All mails are downloaded completely.
Is there a way to search all accounts at the same time?
Something external on my desktop ?
Thanks for your help !
...Using Task Folder as a public folder ...
I want to use a task folder as a public folder .
The objective is to track a sequence of events , and the
requirement is that the view presented to each user must
be the same . For example , while the information in the
task ( that which you find when double clicking the task )
remains viewable for all users , the fields (custom) that
I have set up ( on the view prior to double clicking a
task) do not appear on the other users machine. These
fields will contain information about what is contained
within the task , but if all users cannot see them , it
defeats my goal .
What am I...Using Publisher with a GroupMail Program
I built a one-page e-mail newsletter and converted it to an HTML format. I
try to import it into a mass e-mail program called Group Mail. When I
preview it prior to sending, I see that none of the images or WordArt is
there (I just get those little white boxes with the red "x" in them.).
According to the Graphics Manager all of the images are embedded. What's up?
CSJohnston <CSJohnston@discussions.microsoft.com> was very recently
heard to utter:
> According to the Graphics Manager all of the
> images are embedded.
This means that the graphics are embedd...Enable the option multiple remit-to address feature in MGP 9.0
Please enable the option multiple remit-to address feature that is available
in MGP 9.0.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=665e97a6-6111-46f5-b7dc-a79645d4552...HELP: Display search results in footer section in a split form
I have designed a split form with some search criteria in the Header/
Details Section. How can I display results in the footer section?
Is there a way to do it? Basically I just want to display results below the
search criteria and not in a new tab or window.
Hope I made it clear
Thanks in advance
If you want Quick & Dirty, create a textBox in the Footer and just fill it
programmatically at execution-time.
> Hi All,
> I have designed a split form with some search criteria in the Header/
> Details Section. How can ...Show two value ranges on one axis
How do you show two value ranges of the same data on one axis? (the axis
range is separated by a zigzag/heartbeat style line). e.g. instead of showing
0-50, the axis could show 10-25 and 40-45.
Any help appreciated!
Take a look at Jon Peltier's Broken Y axis example.
"NOKIA" <NOKIA@discussions.microsoft.com> wrote in message
> How do you show two value ranges of the same data on one axis? (the axis
> range is separated by a zigzag/heartbeat style l...when to call DispatchMessage
if I handle an event in an event loop do I still need to call
DispatchMessage afterwards? or is it only for the messages I don't
It's only for message that you don't want any further processing done on.
That said, this is an MFC newsgroup. It's is very rare to implement your own
"event loop" in an MFC application. Makes me think I may not really
understand what it is you are doing.
Available for consulting: http://www.softcircuits.com/jwood/resume.htm
"alexl" <alextheblade@gmai...Having Formatting Remain on "Called" cell using IF function
I'm using an IF function to call some other cells, but I want to have
the various words color coded, eg ("Certified" is green, "Recertify" is
yellow, and "Not Certified" is red). I have the IF function working
correctly, but when it "calls" the cell to have it display the
appropriate word, the color of each word is not brought along with
it...only the text. Is there a way to be able to color code it so that
the appropriate color appears? Thanks!
Zaraf's Profi...Save multiple attachments
I use OL2007 and I often receieve mails with multiple attachements.
Under the Save as option there have been a choice to save attached files
but this option is gone. How do I reinstall it.
it's now under Other Actions.
> I use OL2007 and I often receieve mails with multiple attachements.
> Under the Save as option there have been a choice to save attached files
> but this option is gone. How do I reinstall it.
Can you guide me?
"dlw" <firstname.lastname@example.org&...Multiple Sites for a Contract issue
We have customer who has a Main Headquarters site, and then a number of
addresses with one or more items of equipment. Each item is serialised and
would be returned for repair if it was faulted. A unit would either be sent
in exchange or loaned until repaired and if exchanged then the exchange unit
would become the sites contract equipment.
At present I can’t see how you can do this, as a contract only seems to
accommodate one address and an invoicing address.
How can you change the Location address against a Contract Line Item once
the Contract has been invoiced and is read only ? Is ...multiple calendar resources
New to project, so advice would be welcome.
Looking at setting up a new system for project management. Requirements as
1 project manager creating / scheduling installation projects.
10 engineers (resources?).
When creating a new project is there a way of automatically checking
engineer calendars to see if they are available from within project (so that
we don't have to manually check calendars), and we will need to publish and /
or update project tasks, as they are created or modified, to the engineers
What setup would we nee...Which type of graphic should I use?
I have got this problem:
I have a series of arrival and departure times which I want to put in a
graphic in Excel.
My problem is that I can't find the right graphic for this data, it's
not a line, bar or circle diagram.
Anyone got ideas how to visualise this data?
Thanks in advance,
> Hi All,
> I have got this problem:
> I have a series of arrival and departure times which I want to put in a
> graphic in Excel.
> My problem is that I can't find the right graphic for this data, it's
> not a lin...Pasting Subtotal Results
I have a long worksheet with subtotals. I want to cut and paste th
Subtotal Results only. If you cut and paste, when pasting, it show
everything that was in the subtotal. I just want to paste the resul
of the subtotal. I've tried cut and paste value only, but it doen'
work. Does this make sense? Please Help!!
tchen's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2606
View this thread: http://www.excelforum.com/showthread.php?threadid=39398
I presume you've collaps...Messages showing up as enclosures?
When I send messages from my office email (Outlook 2000, Exchange 2000)
to 2 specific people, my messages show up as an enclosure or an attachment
to a message. Any attachments I had sent are gone. When I send that same
message to others, including my personal email address, they are fine. They
both use Outlook, one uses 2000, not sure about the other. Also, if I paste
a table from Word into the email, they see a string of text, the table is
Any suggestions as to what I can look for to fix this?
...how do I can enter page number with start at 1,038
- My publication with page layout is A5, how to can print two page on paper
_ My book's about 1,800 pages, how to I do enter pages numbers with start at
over 1,001 or 1,214.
What version Publisher? Select booklet from the page layout.
In Publisher 2002-03, insert, section.
Mary Sauer MS MVP
"ductril" <email@example.com> wrote in message
>- My publication with page ...OWA rule with multiple words
If I make a rule in OWA with one word (for example "viagra") in subject this
But how do I make a rule that includes several words in the same rule, based
on the subject ? For example "if there exists words viagra, penis or sex in
the subject, then do..."
I have two tables with all most the same information. How can I update from
one table to another
using an update query. I am trying to replace missing data from one table to
What kind of results did you get? This generally requires the tables be
joined on the primary keys from the tables.
Microsoft Access MVP
"Floyd Forbes" wrote:
> I have two tables with all most the same information. How can I update from
> one table to another
> using an update query. I am trying to replace missing data from one table to
>...query for financial year
I would like to write a query where I do not have to 'hard code' a date range
for a financial year. The financial year begins 1 July through to 30 June.
The column name I am using is [data awarded]. I assume the the code would be
part of the WHERE clause in the SQL statement.
In query design, type an expression like this into the Field row:
FinYearEnd: Year(DateAdd("m", 6, [InvoiceDate]))
substituting your date field for InvoiceDate.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, ...Using a cell to determine a value in a database query.
I've run into a problem recently - maybe there's no good answer, then
again perhaps you can help me come to one.
I have a spreadsheet on which There are three entry fields:
I've managed to map start date to [startdate] in a query and end date
to [enddate] - that seems to work fine. The problem I'm running into
now has to do with the store number field.
In the database, store number is a 4 character field, as of now the
numbers of the store are like 01,02,03,04..HQ,RO. When I try to map
store number to [storenum] in the query, I ...Can i use Office on a U3 stick?
I have ab Sandisk Cruzer Micro with 4GB. I added U3 to it. My question is,
now, you can only run U3 software on the stick. Not even portable ones. U3
software comes as an *.u3p. It has its own platform to be run on Launchpad.
Can you convert Office to U3P portablity?
"march5" <firstname.lastname@example.org> wrote in message
> I have ab Sandisk Cruzer Micro with 4GB. I added U3 to it. My question is,
> now, you can only run U3 software on the stick. Not even portable ones. U3
> software comes...Can't use Word as editor
Recently (and I'm not sure why), the spell check feature
in Outlook 2002 has stopped working properly. While it
once corrected mistakes as I went, now it does not.
I went to Tools | Options | Mail Format, but the boxes
for using Microsoft Word to edit or read e-mail messages
are dimmed and I cannot select them.
P.S. Any thoughts as to why the spell checker (back when
it did work) always checked the original message in my
reply, even though I made certain that the option
to "ignore the original message" IS checked?