Hide a sheet
Is there a way of hiding a worksheet and only allowing it to be unhidden if
a password is supplied? Or is there any other way of achieving this?
Thanks for any help!
I do believe that this might do the very thing I need - I'll test it first
thing in the morning!
"gavin" <firstname.lastname@example.org> wrote in message
> Is there a way of hiding a worksheet and only allowing it to be unhidden
> a password is supplied? Or is there any other way of achieving this?
&...Copying only report sheets
Hi: Happy new year. I created a MS excel workbook which has 4 data
sheets and 4 report sheets. Each report sheet links to each data sheet.
Now I want to create another workbook that will show only the 4 report
sheets. How can I do it in VB code? Agin, in each report sheet, I copy
and paste data from data sheet and thus each report points to
individual data sheet.
Best wishes and thanks
jesmin's Profile: http://www.excelforum.com/me...Publisher 2007 Can i make a calender with holidays already on it?
IS there a way to make a calender in Publisher 2007 that already has holidays
I have a no frills 2009 calendar on my website with the holidays.
http://msauer.mvps.org/publisher_projects2.htm Scroll down a little.
Adding holidays is a manual operation in Publisher.
"Jaci" <Jaci@discussions.microsoft.com> wrote in message
> IS there a way to make a calender in Publisher 2007 that already has holidays
> in it?
...Making reminder alarm ring?
Am using Outlook 2003, with SP1.
I can set reminders to make an alarm sound (like a harp), when a reminder
comes due (it's in Tools > Options > Other > Advanced > Reminder Options >
But Outlook has to be up and running, else no alarm sound.
Is there a way to set Outlook to be sort of in the background (not just
minimized, but really in the background) enough that when a reminder comes
due, the alarm will sound, and either the reminder window pops up or an icon
appears in bottom-right task bar? (Seems like there IS a way for it to check
*e-mails* in t...Help creating two listings from one record
I have extracted "members" from my database. One record will contain
LastName and FirstName, and may also contain SpouseName. Because I am
creating membership cards in Publisher, I think I probably should actually
create another query or ?? that contains one record with either [FirstName
Probablyl something like ...
If SpouseName greater spaces List SpouseName LastName
else next sentence. List FirstName LastName
I don't have a clue how to do this in Access. Appreciate all help.
Try this --
[FirstName] &a...Make (save) a file by using macro recorder.
I am new to macro and using macro recoder to create macro. On one file which
I recieve every week from material department. I need to reformat and create
pivot table. I use macro recorder and everything is working good. However I
need that when my recorded macro end it create a file with the same name with
the date and time it was create. I need every week a new file and I dont want
to replace the one. Please let me know how I can create a new file with the
date and time everyweek when I run my macro. Thanks
This should do it, just insert you...make private appts visible to delegate?
User has an admin as a delegate, with full edit permissions across all
Outlook functions (incl Calendar), and has "Delegate can see my private
items" box already checked. User's delegate, however, can only see the
private items time blocked out in the calendar, and cannot see any of the
Any sage advice or wise counsel??
Ctrl-Alt-Del signing off
Version of Outlook? There is an issue with outlook 2007 where the private
appointments are not visible to outlook 2003 users.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
...Which one first?Install Windows Server 2003 SP1 or Exchange SP2 ? #2
We are running Exchange 2003 on Windows Server 2003. We planned to update
the software in terms of patches, so which one should I do first, the OS
patches (SP1 and onwards) or the Exchange patches ?
By the way, any issue with Exchange SP2 ?
See http://go.microsoft.com/fwlink/?linkid=37488 and
http://support.microsoft.com/?kbid=896742. I would recomment upgrading
"Zul J" wrote:
> We are running Exchange 2003 on Windows Server 2003. We planned to update
> the software in terms of patches, so which one...Chart Title or Text Box Linked to cell & sheet
I need to create charts from data collected via a com port. As i
stands, the data is written to sheet 1. Chart 1 is ready to plot dat
as it is written. Once the data is complete, I copy sheet 1 and char
1. This results in sheet 1(2) and Chart 1(2). All references to shee
1 on the newly created chart 1(2) automatically changes to refer t
sheet 1(2). This applies to data ranges, Chart Title, Axis names.
When creating text boxes refering to sheet1!$A$1, the reference doe
not automacially change to sheet 1(2)!$A$1. Can this be done?
If not, can I create multiple chart titles?
Any help o...Relating one column to another
Stupid newbie question coming up:
Let's say that in column A I have a series (not sequential) of numbers. In
column B I have a word that goes with that number.
In column C, I have numbers, which represent the same words as the number in
column a represents the word in column B.
In other words, I have:
Number Word Type:
1: Banana 2
3: Sausage 4
I want to end up with
Number Word Type:
1: Banana Fruit
3: Sausage Meat
4: M...I'm look for a Visitors Log Sheet
I'm look for a Visitors Log Sheet
...Set One Field based On Another Field
I think I have a pretty simple request. I am looking for some script to put
on an on exit field. Here is what I need it to do:
When a value is put in say $550, if this is greater than a specified limit
in the code I need it to set Field2 to Yes.
So if field1 > 500 set field2 = yes
Real world example:
I have a dollar amount of credit to give to a customer, I want to auto
populate the approval required field with a yes.
Your help is appreciated.
Try: IIf([Field1]>500,[Field2]="Yes") However if the field is a Bit data
type then IIf([Field1]&...Incorporating detail of one sheet into another.
There are 2 excel worksheet. I would like to incorporate detail of sheet
2 into sheet1. e.g
Sheet2 Contain the following details
A B C D E
Agent1 Agent2 Agent3 Agent4 Agent5
1 Apple Cycle
2 Mango Car
3 Banana Bus
4 Coconut Motor and so on in coloumn c , d , e,f and
Now what I would like to do is If in sheet 1 If I select Agent 1 all
the detail of sheet2 which has column as agent1 should appear exactly
as it is in sheet2. And the same thing for Column B, c ...Multiple rendering after one action
Is it possible to render many reports with one link / action?
I'm looking for any programmatically approach, which allows me to
automatically renrder 25 reports to PDF/XLS
Thanks in advance.
You could use RS as a web service to trigger whatever you want. Seee
http://msdn.microsoft.com/en-us/library/ms152787.aspx for details.
"michlimes" <email@example.com> a �crit dans le message de
groupe de discussion : E5B78CCB-7636-4FF8-80A3-7064C09DD9DE@microsoft.com...
> Hi There,
> Is it po...comparing two spread sheets #2
In spread sheet "A" and "B" the last names are in column B and first names are in column C. I want EXCEL to tell me if the names (a name consist of a last and first name) on spread sheet "B" or in spread sheet "A" spread sheet "A" may or may not already contain the names in spread sheet "B". How do you do this is EXCEL?
one way: enter the following array formula (entered with
CTRL+SHIFT+ENTER) in column D of spreasheet A:
0)),"not in s...Matching Columns in work sheets and copying both rows to new
I am trying to match up two different spread sheets based on one column but
to copy both rows to a new sheet.
eg. First sheet has the following headings:
" "Owner CC
" "Product Categorization Tier 2
" "Product Categorization Tier 3
" "Device Name
" "Model Number
" "Mfg. Name
" "CI ID
" "Old Asset ID
" "Serial Number
" "...Only one user at a time can access OWA
Using Exchange 5.5 SP3 on W2K. Only one user can log on using OWA at
any one time. As soon as the first user logs out the next can then log
on, but in a organisation of 1300 - bit of a problem.
Previously we did have things working fine with Exchange 5.5 on WinNT
but a hacking attack put paid to that system!
Have run through MS trouble shooting but found no mention of this
problem anywhere else.
Any suggestions welcomed
firstname.lastname@example.org (Mike Cameron) wrote:
>Using Exchange 5.5 SP3 on W2K. Only one user can log on using OWA at
>any one time. As...Protecting Sheets
Im trying to find a way to protect some data in some spreadsheets that we
have in our company. I know you can password protect the sheet/book, but I
also know that there is a crack for these passwords on the net. Also, waht
we are concerned about is staff leaving & taking the data with them. While
they are at the company they will need access to password so I need to come
up with another way of hiding the data.
What I've been looking into is some code that runs when the book is opened
that uh-hides sheets with data on that are hidden by default. What I do is
check the system of the...Combo Boxes 12-16-07
I know how to create combo boxes in a form. The problem I am having is the
task I need to perform has so much information that needs to be entered. In
summary, I have 65 separate sites with over 260 contractors (EACH SITE HAS 4
CONTRACTORS). I want to create a form where in one combo box/drop down list
you can select one of the 65 sites. Then in the next drop down list/combo
box based on the previous selection it will give you only 4 contractors to
choose from. Is this possible or do I need to do it the long way?
Thanks in advance for your help,
Check out http://ww...looking for a script to make a Distribution List from a text file
Does anyone have a script for making a new Distribution List from a text
file, or CSV file?
I created larger dist lists by using adduser. Then, once the group is
created, I mail enable it.
> Does anyone have a script for making a new Distribution List from a text
> file, or CSV file?
...Taking ownership of HD with different OS
My boyfriend just bought a new pc running Vista and needs to get files off of
the old HD with XP Pro. He's installed the old HD (drive J) into the new pc -
when he attempts to explore drive J he gets the access is denied message. I
told him about taking ownership and disabling simple file sharing, but he's
having a problem because the Vista interface is completely different...is the
procedure a different one if the hard drives have different OS's?
Try run,type: diskmgmt.msc In msc,L.click on the xp hd,go to actions,
all,locate and select "make active",i...Print 12/1/1 in cell (Excel changes it to date or another #
While trying to formulate a magazine order list, Excel changes the number of
magazines needed (12/1/1) to a number other than that typed into the cell.
What I need is the number 12 (for English), 1 (for MP3) and 1 (for Finnish)
in this particular cell. How do I get it to print the actual numbers?
try putting a ' infront of the numbers
"Say Goodnight, Gracie" wrote:
> While trying to formulate a magazine order list, Excel changes the number of
> magazines needed (12/1/1) to a number other than that typed into the cell.
> What I need is the number 12 (for Engli...Multiple Unrelated Queries In One Report or Form?
I've been tasked with generating a report for my boss that provides an
overview of our core database statistics. This includes the total number of
orders placed each month and the total value of orders placed each month. I
also need to provide the same information for purchase orders, quotations and
Each individual query is a piece of cake on its own but how can I display
all of this information either in a form or preferably in a nicely formatted
The queries are all completely unrelated so there's no way I can somehow
joi...Selection from list on main sheet from suplemental sheet in same w
Okay I am new to excell bar drawing little spreadsheets to do my own financing.
I am currently setting up a sheet and need the users to be able to select
from a list of options only and not input thier own text - does that make
also i ahve 12 names on the list and one master with all on - would like the
data entered on to a names list to be automatically entered onto the master
or vice versa which ever is easiest.
sorry if this sounds jumbled but i am totally lost and this has to look
really hot for work!
Kelly - England
You only need to ask in one place, Kelly. :)
*****...How did I populate other cells based on infor from one cell?
Ive got a spreadsheet with staff information such as network username, first
name, surname, department, job title, ethnicity, age etc...
How do I (if possible), automatically populate the first name, surname,
department, job title, ethnicity, age etc... by just typing in the network
Any help is much appreciated!
Check out help on VLOOKUP().
With your data in Sheet1 Col A to Col J; in Sheet2 enter the network
username in cell A1. In cell B1 enter the below formula and copy/drag towards