|
Code Woes
After protecting my worksheet, this code only works sometime - that is the
conditional statements. Also, Cancel=True does not seem to be working as the
cursor remains in the field after double clicking the selection. Here's the
code in its entirety: (It works fine when I UNprotect the worksheet).
Please advise. Thanks!
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, ...
|
11 |
22.09.2006 17:30:01 |
|
|
Add number into one cell to remove from another cell.
Does anyone know how to add a number into one cell and have that same number
removed from another cell? (Even by changing font to match the background)
I want to list consecutive numbers in one cell (eg. 1,2,3,4,5,6) and have
each of these numbers removed one by one as I add each number into another
cell. If I were to enter 3 in another cell my list should now read 1,2, 4,5,6.
It's sim...
|
3 |
22.09.2006 17:24:01 |
|
|
Slow Opening Excel Files
I have a computer that is very slow when viewing files to open from
excel(and word for that matter). The files can be accessed very quickly
from My Computer or explorer but when doing an open in Excel the list takes
forever to generate what files are in the network shares. This does not
happen when logged in as administrator, only as a standard user. Any idea's
on how to fix it? Its ...
|
1 |
22.09.2006 17:21:44 |
|
|
Creating a chart using selected cells from worksheet
I would like to create a pie chart using selected amounts on a
worksheet. The work sheet is set up with columns for each month. In
each colum there are 8 totals with blank cells between each total. When
I do the pie chart it includeds the blanks therefore making a pie chart
with a section for the blank area. How can I just select the totals
from one column?
I have tried holding down shift an...
|
3 |
22.09.2006 16:55:10 |
|
|
How can I find the 10 lowest numbers in a list?
Is there a way to find the 10 lowest numbers in a list? No problem finding
one minimum, but need 10 lowest. Thanks in advance....
|
6 |
22.09.2006 16:48:03 |
|
|
DV dropdown font
I know I can not modify the font on the data validation dropdown. I've
reviewed the code to show how to zoom when DV dropdown cell is active. Is
there a way to determine what the setting of zoom was prior to hitting this
cell, magnifiying the DV dropdown when active and reverting back to the prior
setting after DV dropdown loses focus?...
|
1 |
22.09.2006 16:15:02 |
|
|
VLookup
I need to find a specific P/N on several spreadsheets and add up the sum of
the parts which is entered in column 7. The P/N's are not necessarily on all
sheets....
|
2 |
22.09.2006 16:09:02 |
|
|
Refresh Data in Excel Spreadsheet
How do I refresh data in MS-Excel 2003 w/o manually pressing F2 and enter?
The issue is I have a coulnmn that was brought in from an external data
source as text format, when the column should have been accounting format or
currency format. When I re-format the column to accounting or currency, the
amounts are not refreshed to reflect the new format until I manually touch
the cell by p...
|
3 |
22.09.2006 15:53:49 |
|
|
Automatic Filtering
Hi there,
Is there a way to create a filter that accomplishes the following:
Example Speradsheet
A B
1
2 City State
3 Phoenix AZ
4 Los Angeles CA
5 San Francisco CA
I would like to filter the above data by the state of CA just by typing "CA"
into cell B1 and hitting enter.
I tried playing with advanced filtering, but every t...
|
5 |
22.09.2006 15:47:02 |
|
|
Conditionally consolidating lines within a spreadsheet
I have a payments file (BACS file) that is a CSV file. The file contains
payments to payees containing name, account details and values. Most of the
time each line is unique but occasionally there may be two or more payments
to the same payee on consequtive lines (they are always together) the values
may be the same on each line or not. What I want to do is to end up with only
one line p...
|
2 |
22.09.2006 15:45:02 |
|
|
list contents all cells
I have a 25 page spreadsheet set up graphically, so that text descriptions
occur randomly on the sheets. I'd like to list the contents of every cell as
a table so that I can create a list of all of the text descriptions. It
would be nice to omit cells which have either numbers or blanks. Excel
2003. ...
|
1 |
22.09.2006 15:34:02 |
|
|
Importing
Import from Excel to Word without losing column formatting....
|
2 |
22.09.2006 15:30:01 |
|
|
Shared Workbook Ability For Users To Enter New Records.
Hello! I have been given the task of creating a shared workbook to be used at
30 locations around the country. There will be one user at each location
using the workbook. I have the workbook desigend, heavy with validation,
tips to enter their data etc to make it as foolproof as possible. My only
concern is that as users are entering records how can I prevent them from
entering record...
|
2 |
22.09.2006 15:28:02 |
|
|
Percent of
Good morning everyone, this is a simple formula that I can't put my finger on
for some reason this morning, but I'd appreciate some help.
I'm trying to track training completions
in Cell A2 I have the total amount of employees.
in Cell B2 I have the amount of employees trained.
in Cell C2 I want the percentage of employees trained. Or the percentage of
employees left to be trained.
...
|
4 |
22.09.2006 15:22:01 |
|
|
calculate percentage in pivot
Hello,
Please would someone let me know if it is possible to add a field into a
pivot table which calculates each field's value as a percentage of the total?
For example, I have a pivot table which shows the following
SALES
UK 20,000
France 10,000
Spain 10,000
GRAND TOTAL 40,000
I want to add a column wh...
|
2 |
22.09.2006 15:16:02 |
|
|
Downloading files from an Intranet site to Excel
I have a task to do at work daily, open a webpage on the intranet,
specify the necessary criteria via combo boxes, (always the same), then
I get an option to download a file. I have to Open the file in Internet
Explorer as Saving it corrupts the data, then I can save the data into
a folder on my hard drive, (always the same place and same file name).
Is there anyway i can automate this proces...
|
2 |
22.09.2006 15:05:01 |
|
|
Pivot table headache
Hi,
I have a tricky little problem that I need to solve and I really need some
help.
I'm trying to study attrition rates and get the data onto a graph, the way I
want it.
So I need it set up in the sheet the way I want it before the graph Wizard
gets a look at it.
I have a version of this that I do manually and it has encountered a fair
level of success so now the bos...
|
3 |
22.09.2006 14:59:02 |
|
|
In Excel why does the / key activate the menu bar?
A user wants to enter text in a cell beginning with the forward slash
character.
When she does this it simply activates the File menu but does not enter the
/ in the cell.
Cant find this mentioned in keyboard shortcuts or sticky keys or
accessibility.
Does anyone know how to turn this off?
...
|
5 |
22.09.2006 14:51:01 |
|
|
ribbon changed after reboot
hey, anyone have this happen to them? ...installed TR for Beta2 and was
checking out the changes in Excel. I noticed that the ribbon icons have
changed somewhat from beta2 - things are condensed a bit... however, after a
reboot, my ribbons reverted back to what they were BEFORE I installed the
Technical Refresh...
how can I restore them to the version that they should be? i tried to
...
|
3 |
22.09.2006 14:36:03 |
|
|
Mouse pointer change
I'm running Excell 2003 on Windows XP pro. Everything is set
completely normal and standard. Suddenly the mouse pointer in Excel
(only - no other software as far as I can see) has changed to a big
black square. It still seems to function normally but you cannot see
where it is pointing of course. It only happens in the cells area -
outside in menus etc it changes back to a normal arrow et...
|
1 |
22.09.2006 14:09:44 |
|
|
Form Filling
Dear all
I want to have a excel workbook which work like this
Sheet 1 will have a format of form filling including
Employee Code
Name
Address/Phone No/Email
Age
Date of birth
Sex
Marital status
Date of marriage
Spouse name
Hobbies
Users pic
“SAVE†function at the end
Any user can feed his data in this sheet
As soon as he press “SAVE†button, all data will get Saved in a...
|
1 |
22.09.2006 13:29:02 |
|
|
How do you get around &T converting to time in header.
I need to use &T as part of text in an excel sheet header. It converts to
time. Is there a way of getting around this conversion?...
|
2 |
22.09.2006 13:01:25 |
|
|
Hyperlinks in Excel
Is there anyway to create a hyperlink in Excel(2003 sp2) to another document
that opens in a new window? Any help on this would really be appreciated....
|
4 |
22.09.2006 12:33:01 |
|
|
how do i show a zero in front of a number ie 0625 in excel
I am trying to enter numbers in excel, and would like to see the 0 in front
of the number ie 0625...
|
2 |
22.09.2006 12:31:02 |
|
|
No. of rows selected from auto filter not visible on toolbar?
When i put an auto filter on a column on excel, and select a particular
option from the drop down filter menu, the number of rows selected for that
option is not appearing at the bottom left hand corner on the toolbar.......
|
3 |
22.09.2006 12:05:02 |