Prevent clicking on a cell
I want to run the code below to prevent a range of cells from being selected
if the Range("Q7") = 1. I have all cells on the worksheet locked but the
user must be able to click on the locked cells to trigger a userform so I
have to check Select Locked Cells. So is there any way make the
If Range("Q7") = 1 Then
Range("B5:C5").Locked = True
>So is there any way make the
> Range("B5:C5") unselectable?
No but you can stop them staying there.
Private Sub Worksheet_...send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with
one or two fields changed (for example the name of recipient and the
date).How canthis be done?? I would also like to be able to save the
e-mail and use it again and again.
can anyone help
If you have Word installed and it's the same version as Outlook (both 2003,
for example), you can do a mail merge between the two. This would allow you
to set up the text the way you want it to, and you can save the document for
future use. Look at the following page for further information:
http://www.slipstick.com/con...if cell is text move left one column
ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
Dim lngRow As Long
For lngRow = 1 To Cells(Rows.Count, "B").End(xlUp).Row
If Not IsNumeric(Range("B" & lngRow)) Then
Range("A" & lngRow).Value = Range("B" & lngRow).Text
Range("B" & lngRow).Value = ""
...IF Statement #7
I'm trying to create an IF statement whereby if a certain stock in my portfolio goes up for that day's activity, it will display a green up arrow; if it goes down, a stick person dangling at the end of a rope. (Just kidding about that one). The GIF pictures I want to use will be in the same subdirectory as the Excel spreadsheet. I'm using Excel 2003.
Thanks in Advance!!
If you would care to use the WingDings font instead of a
GIF, try this:
=IF(K3>1," J",IF(H3>F3,"K","L "))
Then format the result as WingDings. You get either a
smile...Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
Data",IF(V7="Yes",&qu...why does sorting change a scatter plot graph?
Why does the way a spread sheet is sorted change the look of a scatter plot
graph??? the graph is just a plot of two points, (X, Y) and these two points
are definded by two collumns for a given row. The two collumns don't change,
and the row all stays together, so why does it change where points are
plotted out on the graph when you re-sort it?
Usually, for an XY (Scatter) chart, with values of X in a column and
corresponding values of Y in an adjacent column, for three or more points,
Excel assumes (correctly) "Series in Columns."
But, when you have only...Date display in Excel
Format column of cells as Date, display as mm/dd/yy. Date
entered into cell, shows up correctly in the text entry
field at the top of the screen, but the data on the
worksheet displays as "33747", or similar number. Only
happening on one workbook.
Try tools|options|View tab|uncheck Formulas.
> Format column of cells as Date, display as mm/dd/yy. Date
> entered into cell, shows up correctly in the text entry
> field at the top of the screen, but the data on the
> worksheet displays as "33747", or similar number. Only
> happening on one...Changing Prices in HQ.
Hi, I have this little issue. I want to change the put items on promotion
using the price wizard using HQ. Unfortunately if I have stores who has
differents prices for a same item the wizard do not make the proper change
becuase it use the price already stored in the master table. Does anyone saw
this issue before? Who was solved?. Thks in advance for your help. Rgds
The easiest way to look after this is to not change any data on the ITEM in
HQ, but to simply do the worksheet for altering the sale price and then send
it to the respective stores.
Then in the works...How do I extend a underline across an entire cell?
When working on a financial statement, I was curious how to 1. Have a line
extend across an entire cell even if the number is only 2-3 digits and 2. How
to apply a double line under a number without using the = sign in the
Look on the formatting toolbar for Borders
Regards Ron de Bruin
"Lindsay" <Lindsay@discussions.microsoft.com> wrote in message news:F4C9ED6C-7F2D-4277-86CC-6FA46D315DA5@microsoft.com...
> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire ce...Content of emails is changing without any reason !
I changed operating system last week. From Win XP to Win 7. Used to work
with Outlook Express at full satisfaction.
I could transfer most of my emails automatically with export/import features
of Microsoft software.
But I suddenly discover 1 very big problem (bug ???)
I am used to work with several maps, and hereby go to several levels deep.
Such as :
Date of action
Name of patient
So sometimes maps can go several levels deep.
When I check ema...Saving toolbar changes
After spending a lot of time to customize a toolbar in Excel 2003, it disappears when opening up another file, or starting the app again. I repeatedly change it, save it as XLB, XLT, save multiple copies in every possible location...but the damn thing always defaults to its own toolbar settings. This makes toolbars almost useless.
How can one insist that PPT use YOUR toolbar setting, rather than its own default
If I have a lot of tool bar changes to make, I close all the
workbook that are not hidden then unhide my personal.xls
from the Window menu.
I don't know why...C# Adding Days to a Date
I have 2 objects:
objContract.activeon and objContract.expireson.
I am trying to add 364 days to objContract.activeon and assign it to the value
// Contract Start Date
DateTime dt = DateTime.Now;
objContract.activeon = new CrmDateTime();
int iFound = 0;
string sTemp = "";
if (objAccount.paymenttermscode.Value == 1) // due on receipt - use Todays
objContract.activeon = objInvoice.CFDinvoicedate;
else // ...Separating Date and Time in a cell
I have a column of cells in the format "11/01/02 06:21". I would like to
separate the text into 2 cells - one with the date and the other with
the time. My attempts with LEFT and RIGHT have been unsuccesful. Thanks
for your help
Message posted from http://www.ExcelForum.com/
For the date use
replace A1 with the first cell of your range
you probably have to reformat the first to
mm/dd/yy (or whatever the setting is)
Note that you can do this by just using format but if you want to compare to
other cells with just pure d...Change cannot be saved due to sharing violation
I've this message while saving the excel file even if no change ha
been done to the file. There is no share on this file (exclusive use)
File resides on a network drive
It's very disturbing
Thanks for your help
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=245
View this thread: http://www.msusenet.com/t-187102186
Thanks for your answer, I will try tomorrow noo
----------------...Changing query execution sequence
I got a spreadsheet which would execute a bunch of queries. It's noted that
the queries are executing in the sequence of when it was added to the
spreadsheet. Does anyone out there know of a way to switch the order without
deleting and recreating them?
...cell contents revert to 0 when i click on the next cell
I put a number into a cell click on the next cell and the first cell reverts
to 0. If I format to number with 2 decimal places it will be ok but when I
try to take out decimal places it goes back to zero,
You haven't said what number you are trying to put into the cell, but I
suspect that the number is less than 0.5.
A quick test shows that if you set the cell to no decimal places then enter
a number less than 0.5 it is displayed 'rounded down' so it will show as
zero, if it's 0.5 or above it displays as 1.
If you need to put numbers less than 0.5 into youe c...Email Statements from Collection Module
When I attempt to email statements from the Collection Module I am getting an
error message, ' Wrong number of arguments to 'RM_Statements_Update_Header'
...Accommodating for empty cells in this formula?
I have a formula in cell H21, for example, reads like this:
is there a way to adjust the formula so that an empty cell in G21 doesn't
give the #VALUE! in subsequent cells in column H?
Just to give a similar example, this formula =SUMIF(A1:A9,"<>0") adjusts for
any and all empty cells in A2 to A9. It no longer matters if any of the
cells are empty, the formula correctly gives the correct addition of A1
plust a sum of everything between A2 to A10 without any #VALUE! results.
Was hoping to have the formula above als...SQL Server Connection Failed
Hi everybody, this is my scenario:
1. Windows Server 2008
2. WSS 3.0 + MOSS 2007
3. SQL Server 2008.
i'm having this problem: "Login failed for user 'sa'. Reason: An error
occurred while evaluating the password. [CLIENT: 18.104.22.168]".
in this momment i can't see any application from sharepoint. somebody knows
how can i do?
i don't change the sa password. i don't change anything in the sharepoint
configuration. since two days ago i'm having this problem. pls, is very
urgent, because i have to deliver this server the next monday to the...Automatic changes in cells
Hi for some reason I now have to save my work for any formlas etc to change
when I update a worsheet, how can I stop this as it is a pain and sometimes
I need to do changes to see how they work before saving the work.
Click on Tools | Options | Calculation tab and set to Automatic
calculation, as it is probably set to Manual. You can press F9 to
force a recalculation under a manual setting.
Make sure you save the file with the Automatic setting, to avoid it
happening next time.
Hope this helps.
On Feb 1, 11:42=A0am, Office 2004 Test Drive User
<heepenm...@yahoo.co.u...Change the text of a shape rather than its master
I build custom masters by mixing two general shapes, say square and
circle together, and have text on both the shapes.
But after I drop an instance of the master into a page, I cannot
modify the text of the instance. To do so, I need to modify the text
on the master, which is non-sense for me.
How to change the text of a shape without modifying its master?
How are you doing this? By code or by the UI?
Are you grouping the shapes? If you drag two shapes to the stencil, it will
group the shapes. So instead of a square and a circle you have three shapes.
A Square, Circle and the...cell colour change when set markers are reached
i need to get a cell to change colour when markers are reached eg
a qualification lasts 12 months. what i want to do is have the cell change
from yellow to orange to red as the expiry date gets closer.
If column A contains expiry dates then select column A,
=DATEDIF(TODAY(),A1,"m")<1 red for 1 month
Click Add button, formula2:
=DATEDIF(TODAY(),A1,"m")<2 orange for 2 month
Click Add button, formula3:
=DATEDIF(TODAY(),A1,"m")<3 yellow for 3 month
Adjust number of months as you like!
Regards,...date function #3
This is a multi-part message in MIME format.
I have a cell A1 with date 5/2/07. If in cell A2 I do month(A1), I get =
5. Is there a way to return May instead? either through a command or =
formatting? I can reference cell A2 with the 5 with a if(cell =3D 5, =
"May", ) in cell A3, but the date in cell A1 varies from Jan to Dec and =
the 12 embedded if's in cell A3 are too long (that is the error I get =
when trying to do so), plus i...Changing ip address of exchange server #2
I have a back-end server and a smtp server in DMZ.
I want to change ip address of back-end server. are there any issues?
all incoming and outgoing emails are going via smart host.
No issues at all as long as you remember to change all the references to
this server in your firewall, SMTP scanner etc.
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
> I have a back-end server and a smtp server in DMZ.
> I want to change ip address of back-end server. are ...Backing up databases on remote SQL
I recently followed one of the MS articles on how to move GP 9 sql database
to a different server. Everything went well except when trying to run the
backup option from the GP9 server.
I currently have a server with GP9 installed and another server with SQL and
the GP databases. When I try to run the backup from the backup option on the
GP server it says " You must be on the server machine to perform this task".
presume this is because the SQL is no longer on that server. The SQL server
has a backup routine of its own, but I would like our finance users to have