How to print limited columns in sheet
I have a page in spreadsheet
Lets say columns a to z
A and B are for stock figures and also M and N are for stock figures
Is there a way to print the sheet A to Z but not have columns A,B,M,N on the
I am looking for something easy as I have to get one of the office girls to
do this once its set up.
"S" <firstname.lastname@example.org> wrote in message
>I have a page in spreadsheet
> Lets say columns a to z
> A and B are for stock figures and also M and N are for stock figures
> Is t...protecting sheet with combox
i'm trying to protect a sheet with a combo box in it. the combox list a
bunch of values. each value you pick is linked to a formula which
changes a price value in a different cell. i would like to protect the
sheet so that the money value that appears in the cell can't be changed
by the user. whenever i try to protect the sheet i then can't change
the values in the comb box . i want to be able change the values in
the combo box but have the formulas and automated cells protected. any
~~ Message posted from http://www....Password Protect Two Sub-contact Lists
I have a regular contact list, and within this list I have two
subcontact lists. One is personal, and the other is personal business.
How can I password protect the personal and personal business lists?
Thanks for any help!
Sorry, I just realized that there's a newsgroup dedicated to contacts.
I'll post this there.
> Hi everyone!
> I have a regular contact list, and within this list I have two
> subcontact lists. One is personal, and the other is personal business.
> How can I password protect the personal and...Can't use reference to another sheet in Data|Validation|Allow List?
How can I do this...?
I wish the user to input data on Sheet1
but in Sheet2 use Data|Validation|Allow List to create a list of what is
input on sheet1.
I get an error when I try this...
is there a way to do this?
Create a defined name pointing to the validation list, and use the
name in the list source property.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"hutch" <email@example.com> wrote in message
> How can I ...Passwords #5
I would like to password protect a workbook so that when
the workbook is selected to open a dialog box pops up
asking for the password and after the password is entered
correctly the workbook will then open. Thanks for the the
Todd, do a save as and look under options, depending on what version you are
using and set a password to open
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address t...converting to access #2
The original spreadsheet was a price list which included
product code, price, and other info. I can convert all of
the columns except for the price column which is
called "List". I tried to solve the problem by copying
the "code" and "List" columns into a new spresdsheet and
change some of the settings for the "List" column
including changing the format to general number, wider
The code column will convert when tried alone. The List
column will not.
What am I doing wrong?
I suspect that "List" is a rese...Passwords
Hi, I have a password field in a database. How do I set it so that a
user can only type in 7 characters for a password. and if they type
more an error message will appear?
> Hi, I have a password field in a database. How do I set it so that a
> user can only type in 7 characters for a password. and if they type
> more an error message will appear?
You may use the ValidationRule and ValidationText of the field in the
table design view. Setting ValidationRule to Len([YourField])>7) will
raise an error in your case.
--> stefan <--
...Keep user passwords
We've just finished installing a new Exchange server and connecting it to a
separate DC. We used to have everything on the same server but we'd like to
be able to scale our solution better in the future - therefore the new
setup. Users are primarily connecting to Exchange by means of RPC over HTTP
from clients that are not part of our AD.
The old setup allowed users to save passwords if they configured their
clients to use NTLM authentication and followed the directions in this
This worked both for RPC...how to key in one table and show in another tables in Access 2003
I have many tables how can I link them together and as I type certain
information in the master show in the other tables.
You should not duplicate data in different tables. This constitutes
redundancy and leaves the database open to the risk of inconsistent data.
Tables should be related to each other by a foreign key column or columns in
one referencing a primary key column or columns in another. Non-key columns
should only be in one table.
The process of eliminating redundancy in tables is known as 'normalization'.
Here's a brief description of how it works:
Normali...Need to print the second sheet only if it is active
I have a two page excel worksheet, I always want the first page to print, but
if there is a lot of information and the second sheet becomes active, I want
that to print as well. But only if it is active.
Select the Data Range and give Cntrl+P and check the [Selection] Option
Button Under the [Print What] heading and give Ok...
While selecting the data range and printing the selection only will let
excel to print the sheets which is having the data.
Remember to Click Yes, if this post helps!
"Lori Mae&qu...How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the
password. Is there any way that I can gain access to my worksheet?
There are tons of FREE good Excel password 'cracking' tools. Your favorite
search engine should get about a gazillion hits on a phrase like "crack excel
password" or "excel password cracker".
A good one that many report great success with can be found at:
> I password protected an Excel spreadsheet and now can't remember the
> p...quick copy worksheet into other sheets in same workbook
I am wanting to copy a worksheet that is set up to show student results,
targets and achievements into approximately 150 other worksheets in the same
workbook. Is there a quick way of doing this other than copying and pasting?
I want formats, colours and column widths etc to stay the same. In other
words I want to produce about 150 identical copies of my layout as quickly as
possible with the minimum of effort.
I am using Excel 2003.
Thanks in advance for any help and advice offered
Right-click on the worksheet tab and select "Move or Copy", then use the
dialog box that appear...Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help
You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
M Imran Buha...How to protect cells?
I would like to protect a range of cells (A2:D24) with a password for a
group of users that would make changes to cells in this range. Then on
the same sheet, also protect a range of cells (E2:E24) from everyone but
me. Is this possible?
Please don't multipost.
See the thread in .programming.
"Mark F." <firstname.lastname@example.org> wrote in message
> I would like to protect a range of cells (A2:D24) with a password for a
> group of users that would make changes to cells in this range. Then on
> the same she...Password
I am working with publisher 2007. I finished my site last Dec. and went to
It is not letting me make changes because it does not like my password. I
can not figure out how to go in a reset everything from my provider.
I was also trying to see if I could find web publishing wizard, which
doesn't seem to exsist with 2007.
If you are saying you forgot your password then contact the ISP Tech Support
and they will reset the password to something like 1 2 3 4 or something
other that is very simple. They will also instruct you to change it to
somethin...How to refer to current sheet in a formula
I want to have a named formula which always refers to a cell on the
sheet it is on. When I define the formula it is automatically changed
to refer to the sheet active when I defined it. E.g. =$B$2*3 becomes
=sheet1!$B$2*3. This is no good for use on sheet 2 where I want the
formula to refer to that sheet's $B$2 (equivalent of sheet2!$B$2). I
have tried entering =!$B$2*3 which works initially but recalculates
using the $B$2 on the sheet active when the recalculation is done.
Poxypig's Profile: http:/...Passwords #3
For some reason, it will not store the password. I have
checked the box that says "remember password", but, each
time I try to log in. It will ask me for it. Any ideas.
I am thinking about recreating the profile for thismailbox.
I am a consultant, and my customer doesn't know how (or
won't write down what I tell them) to do this.
...Protection from copying
I have a workbook with hidden cells that I would like to protect (leaving
certain cells visible for input). However, even with password protection on
the entire workbook, a user can copy all of the cells into another workbook
and view/edit/change all of the cells in my workbook. Is there a way around
If it's formulas you want hidden, use Format - Cells - Protection - Hidden.
Then protect the sheet (Tools - Protection - Protect sheet). If it's data,
forget it. Users can copy/paste cells , copy the sheet, take a picture of
the workbook with PrtScrn (or with ...Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy
and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
user. my client want to know how to enable it. hope for your prompt action.
Only works for SQL 2005. If you client wants to use a beta database server...
> I'm curious why are the Change Password Next Login, Enforce Password Policy
> and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
> user. my client want to know how to enab...Outlook crashes when trying to access folders #2
My Outlook 97 as supplied with Office '97 pro has developed a fata
error. I am running Windows XP Home edition with all the lates
patches. I have created a number of folders from within outlook whic
contain data about various clients I have. I have about 25 entries a
present. Today when attempt to access any of these folders after abou
15 seconds I get a warning message saying that Outlook must close an
send an error report to MS.
All of the other Outlook functions appear to work without an
problem and I am able to access the folders and the data in the
without any problem through E...how can I format sheet 1 if the value is found in sheet 2?
I'm all employee data in sheet 1, in sheet 2 I'm using vlookup function to
retrieve employees for whom I issued certificates on a each day. My question
is, how I can mark those employees in sheet 1 for whom Ive already issued
certificates from those for whom I didn't. I tried conditional format
function, but it didn't work, as it is in the separate sheet.
Thank you for your help
Try the responses in your later post ..
> I'm all employee data in sheet 1, in sheet 2 I...i need to make the sheets name come from a cell
I am wondering if its possible to name a sheets in excel, with data held in a
cell in the same worksheet
thanks for the help
do you need this automatically?. If yes try the following code in your
Private Sub Worksheet_Change(ByVal Target As Range)
if target.address="$A$1" then
if target.value<>"" then
"sam wildig" <sam email@example.com...password prompt when no password is set.
thru a series of unfortunate events I had to reinstall my os and all of
my programs. I was using ms money 2000. I have always kept the main
*.mny file but lost my backups. When i reinstalled money and tried to
open my mny file I get a password prompt. I have never password
protected the file and when i tried to run a password recovery program
it says "no password set". I do have older backups of this file but
they are too old to be of much use. But i am able to access them. any
suggestions would be appreciated. Thanks
The password prompt often appears when you open a dataset m...Network password #9
I don't use passwords and now i am prompted to enter a
network password or my computer will not connect to email
account. Any thoughts
If you are still having problems after applying both the SP 1 & 2 patches,
then see if this article addresses your problemL
OL2002: The Save Password Setting Is Not Saved When You Connect to a POP3
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
accoun...protecting data when updating/importing
I have text files that are updated every day via a mobile link (SIM card).
Each text file is also automatically imported into an excel spreasheet (upon
opening the spreadsheet) so that I can look at graphs of the data when I want
This all seems to work fine, but one day half of the data failed to be
updated via the mobile link. Could it be that I happened to import the data
into excel just as the data was being updated from the mobile link, and the
update was interrupted? If so, is there a way that I could create a mirror
image of the text file so that one copy is used for the m...