protecting a group of cells not a whole worksheet
I would like to protect a group of cells and not a whole worksheet but I haven't been able to figure out how to do this. I think this would be the best way for what I am wanting to do. I have a spreadsheet that I send to 13 people. They make changes and send back to me and then I have to up-date the changes. If I could protect all the cells except for the one they enter in - then I could save the file on a shared drive and it would eliminate me up-dating. Is there a way to do this?
select the cells for which you want to allow entries. After this goto
'Format - cells - Protection&...In creating a spreadsheet how can I lock a formula cell only?
I am trying to create a spreadsheet in Excell and want to lock the formula
cells to they cannot be typed over accidently destroying the function??
By default all cells are locked when the sheet is protected.
Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
Now Tools>Protection>Protect Sheet. This is mandatory!!
You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being ...Adding a control button to insert a date in the active cell.
I'm trying to make a control button that will populate a static date (Ctrl
+) in the active cell that the person has chosen.
Any input is greatly appreciated.
ActiveCell.Value = Format(Date, "dd-mmm-yy")
Gord Dibben Excel MVP
On Tue, 15 Feb 2005 09:41:08 -0800, "Mike" <Mike@discussions.microsoft.com>
>I'm trying to make a control button that will populate a static date (Ctrl
>+) in the active cell that the person has chosen.
>Any input is greatly appreciated.
Sub Time_Stamp()...find which column has the maximum value
I have to check each row for the maximum value in that row. But instead of
writing the maximum value of that row, I have to write the column number of
that maximum value. The very first row of my dataset goes from 1 to 100,
indicating 100 columns, and is there only to number the columns. So, the
column number has to be picked from that row.
For instance, in row 20, the maximum value is 10, and it is at column 56.
How can I as output of a formula (or conditional formatting) get as answer 56?
(remove nothere from email addr...Formulas In Cell Comments
Is it possible to run formulas or vba code inside of a cell comment
If so, how?
Not sure about VBA code but something like this might -
Dim sFml As String
Dim cm As Comment
sFml = "A1*4+A2"
Set cm = Range("A1").Comment
If cm Is Nothing Then
Set cm = Range("A1").AddComment
Range("A1").Value = 20
Range("A2").Value = 10
Range("C3").Formula = "=foo()"
Func...changing cell reference via another cell
I have a spreadsheet with a tab (called calc) containing columns of
calculations. The next tab (called D) contains a diagram which pulls numbers
off of column D of the calc tab. I copy tab D to a new tab (by right
clicking on the tab and selecting copy) and I rename the new tab as E. I
want the cells in tab E to reference column E in the calc tab. Currently, I
do a Find/Replace, changing 'calc'!D to 'calc'!E. Is there a way I can
automate this so I don't have to do the Find/Replace. I was hoping I could
just type E in a cell on tab E and it would be set ...Go to a cell automatically
How can I make the active cell the cell after the statement:
"End("B1").xlDown.offset(1,0)" to start a paste operation.
Thanks in advance.
"Mercury" <email@example.com> wrote in message
> How can I make the active cell the cell after the statement:
> "End("B1").xlDown.offset(1,0)" to start a paste operation.
> Thanks in advance.
Range("d1").Copy Range("b1")....custom cells format
I want to format a cell so i can transform 1256453 in 125.56. How can i
format a cell so i can view first number as 125.56?
Thanks for your help.
You have a couple of replies to your other posts.
> I want to format a cell so i can transform 1256453 in 125.56. How can i
> format a cell so i can view first number as 125.56?
> Thanks for your help.
Go to Format -->Cell -->Number-->Custom
There you type
You get the results as desire
> I want to format a cell so i can tra...Automatically Fill Empty Cells in a Column
Is it possible to automatically fill empty cells in a column with the data in the cell above it?
Select the column / range. Then Edit / Go to / Special / Blanks. This will
select all of the blank cells in the range. Type = and hit the up arrow and
then type Ctrl Enter. To fix these values use Copy then Paste Special /
"Deignan" <firstname.lastname@example.org> wrote in message
> Is it possible to automatically fill empty cells in a column with the data
in the cell above it?
...where do i find my 25 charactor numbers to register.
Where do i find the 25 charactor number to register my micrisoft. It was
installed on the puter when i purchased it. But i have no idea. Thanks
Look in the box for a manual that might have a sticker on it with the #.
There might also be a sticker on the back of the computer case (where all
the cords plug in).
"Beverly" <Beverly@discussions.microsoft.com> wrote in message
> Where do i find the 25 charactor number to register my micrisoft. It was
> installed on the puter when i purchased it. But i have no id...Display cells with data validation
Using 2003 - Is there a way of displaying cells that contains data validation
restrictions? I've received a spreadsheet from someone with lots of
restrictions on it and want to see which cells are affected.
"Anita" <Anita@discussions.microsoft.com> wrote in message
> Using 2003 - Is there a way of displaying cells that contains data
> restrictions? I've received a spreadsheet from someone with lots of
> restrictions on it and want to see which cells are affected.
>...Fill a spreadsheet automatically after one cell is input
Okay, I know how a normal autofill works. However, how do I do it in
Spreadsheet has formulae. User makes a selection and VLookup instantly
populates the rest of the table with information. So how do I
instantly populate said spreadsheet where it autofills the row once it
is selected. An IsBlank() formula works in theory, but then I have to
autofill the first 500 rows or so. I want something that just
dynamically moves to fill the row as the user gets to it.
Is it possible?
For what you are stating I think that you are looking at some way or adding
the extra data once the us...finding days in Excel #2
Thanks - they both work really well - cheers
Bob Phillips Wrote:
> or even
> "icestationzbra" <email@example.com> wrot
> message news:firstname.lastname@example.org...
> > i hope you meant a worksheet function which would return the weekda
> > the date entered:
> > =TEXT(WEEKDAY(TODAY()),"dddd")
> >...Run a macro when cell value changes
I have a macro that I would like to run, onlly when a particular cel
value reaches a pre-defined value.
I really do not know how to do this - I have looked on help features
but to no avail. any ideas
Message posted from http://www.ExcelForum.com
right click sheet tab>view code>copy/paste this>modify to suit>save
Now when cell c1 calculates to >32 your macro will fire
Private Sub Worksheet_Calculate()
If Range("c1") > 32 Then call yourmacro ' MsgBox "Hi"
"Emea training >&quo...Default View Advanced Find
When I click Advanced Find, it defaults to Contacts.
What are the steps for having it default to Accounts which is what my
salesforce primarily searches on? Thank you.
The default is hardcoded to Contacts within
A work around would be to modifiy the window.onload() funciton in
Just add the line:
Or one of the following other value's:
1024...find default "look in"
Is there a way, I can make Excel default the "look in" to 'values' when
I open the Find dialog box, rather than formulas
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
It looks like excel tries to help by remembering the last thing you used.
So maybe you could have a dummy workbook that you put in your XLStart folder
that does a Find with the settings you like:
Worksheets("sheet1").Cells.Find...How To Find and Delete Duplicate Files? http://DuplicateFilesDeleter.com
How To Find and Delete Duplicate Files? http://DuplicateFilesDeleter.com
http://DuplicateFilesDeleter.com is an innovative tool that can
recognize duplicate audio files even if they are stored in different
file formats and not marked with ID3 tags.
It will find fast all similar or exact duplicate audio files in a
folder and its sub folders.
Unlike common duplicate file finders it will actually "listen" to
music and can recognize a song even if it is saved in different file
Supports MP3, MP2, MP1, MPA, WAV, OGG, AIFF, AAC, MP4, FLAC, AC3,
WavPack (WV), Musepack (MPC) an...Find 2 highest point to form resistance line
Have left a post for finding 2 lowest point for form a support line.
Now, would like to find 2 highest point to form a resistance line.
Data is from an array for formula.
In this case, should choose 91.27 and 87.96 to form resistance line.
Although 89.95 is higher than 87.96, line is forward plotting.
Is it possible?
If the highest in last row, can show "No line".
I put your data in A1:B5
In E1 I find the maximum with =MAX(...excel 2000 downloadable template for amortizations. can't find
A year ago I found a place to download an amortization template in MS Excel
2000. Monthly and Bi-monthly. I believe it was an article written by a user
who was just passing along the information. I can't find it now. I lost
everything on my computer to a virus and really need this back. Any help
will be appreciated. Thanks
Hi Pyro Princess,
"pyro princess" <email@example.com> wrote in message
>A year ago I found a place to do...VBA copy xls to ppt
This may be basic but from an excel spreadsheet I want to automate the
copy/paste of charts to a ppt deck. Altogether there are around 300 charts
to be crammed into 50 slides.
Any suggestions on tutorial/VBA coding would be appreciated!
...How can I make the graph omit blank cells in the data set?
I've been workin' on the problem below that I've written a few days ago but
got no answers.
It's easy to select spesific cells to another column
for ex: cells belong to type A
then I draw the graph but a new problem occured, there are empth cells and
mygraph counts them
next question: how can I omit the blank cells from my data set while
Thx a lot :)
I have a mixed data set as exampled below,
D 4...Learning VBA
Can I get some suggestions of a book or website that is good for learning VBA
at a beginner's level for use in Access? I am planning on buying Paul
McFedries' VBA book, because I love his book on Access Reports, but first
wanted to see if anyone here has some suggestions.
Beginning Access XXXX VBA, Smith and Sussman, Wrox Press
"Andeva" <Andeva@discussions.microsoft.com> wrote in message
> Can I get some suggestions of a book or website that is good for le...Impoting photos7 in Excel VBA
I almost completed my application, and I needto import some photos in the
document. It is about 20 photos, and I mamaged routine for selecting and
placing phots in the documnet. Problem is now that excel file is too big,
when photos are of 2-3 MB each, excel file becom 20 MB an more. That case
all starts to work very slowly, and colaps.
If there is solution, to have some VB command in to the code to reduce size
of the photo during importnitng. It is posible to compress photo in the
Exce, but don't know how to make same thing automated in the VB code.
Much appreciate if any...SEARCH, FIND, LEFT...??
I have comma delimited strings of various lengths. I wish to extract
the first 3 fields as a comma delimited string. Since the fields are of
different lengths, I've hit a brick wall.
107,165,72,9,30,10,4_________________ Result => 107,165,72
1,87,4,40,12,20,75,40,39,9,82,24_____ Result => 1,87,4
5____________________________________ Result =>5
120__________________________________ Result =>120
12,327_______________________________ Result =>12,327
mussels______________________________ Result =>mussels
2,263,106,82,19______________...Valid for advanced find...?!?!
I just realized that some of the attributes are “valid for advanced find”
and some are not.
So why is for example “Business Type” (Attribute “businesstypecode”) not
“valid for advanced find”? I think it is necessary to find/filter your
customer base by Business Type.
If you look at the metadata browser
you can find which attributes are and are not valid for Advanced Find.
account/businesstypecode is indeed invalid for Advanced Find.
Why is it like this? Presumably the answer is "Too hard", "Insu...