Customization: disabling built in features
I would like to disable/remove some of the sections on the left hand
side of CRM. For example, on the home screen I would like to remove
the Invoices section since we don't use these. And on the Account
level I would like to remove the Notes and Contracts sections for the
Is this possible?
...deleting multiple rows
I need to be able to delete multiple rows out of a worksheet. What I need to
be able to do is have a function/macro that can identify a string of
characters and then delete all the rows that have those characters.
For example, if row 4, 18, and 45 all had "blue" in them (assume column is
A), then I need something to go delete row, 4, 18, and 45.
At the top of my worksheet I will have several, probably about 3, criteria,
such as, "blue", "red", and "green" that will all need to be deleted.
Now here's where I really need help. A row may ...Select a certain number of cells in a row
I'd like to have the macro to select row 5 to 10 in the active column. May I
know what is the VB code to write?
dim myRng as range
dim myCol as long
mycol = activecell.Column
set myrng = .range(.cells(5,mycol),.cells(10,mycol))
I'm not quite sure why you want to select that range. But for the most part, if
you act directly on the range (and avoid .selects), you're code will work faster
and be easier to modify.
Dolph...Drag and Drop
I'd like to allow drag'n'drop operation to list box (CListCtrl), placed on
I checked Accept files in properties of this CListCtrl, created
OnDropFiles(HDROP hDropInfo) method of the dialog and placed afx_msg void
OnDropFiles(HDROP hDropInfo); in .h file.
When I drop file, cursor will change but OnDropFiles isn't called.
What's wrong with that?
The OnDropFiles() handler must be in the CListCtrl-derived class, not the
"Deli" <deli_@ANTISPAMop.pl> wrote in message
&...Filtering data by custom fields in pivot tables from Visual Report
I have recently upgraded to MS Project 2007 and like the visual reporting
feature, except I really need to filter and group the resulting pivot table
in Excel by custom fields. For example, for task usage, I cannot filter my
pivot table to show only the tasks that have costs > $0, thus my table ends
up showing too many lines and a lot of 0's. I would also like to group by
department/ function which I put in a custom text field. How do I do this?
I saw related posts about saving the file as an Access database and then
creating the pivot table by connecting to the datab...Keeping Custom Properties When Forwarding or Replying to a Message #2
We have emails saved on the file system, that is kept track of by
another program. These emails have custom properties attached to
them. There is no custom form, just custom properties. These fields
were originally added using objPost.UserProperties.Add. We need it
so that when someone opens up one of these emails through the file
system, and then replies or fowards the message, these custom
properties are kept in the reply. This is so the external program can
track these emails. Is there a way this can be done? We could have
these emails opened up using an Outlook command line that i...Combine rows to print on one label
I have imported student information into an excel spreadsheet (use Excel
2003). Each student has one row of information for each course they take. I
need to print one label for each student and each course & grade must print
on a single label. How do I combine the rows to cause this to happen?
assuming the info in the row is divided into separate columns for name,
course, grade, etc you can do a mail merge in word using the spreadsheet as
the data source
> I have imported student information into an excel spreadsheet (use Excel
> 2...Combining Pivot Tables
I have a data set of around 100,000 rows which I have imported into
excel in two sheets (~50,000 rows each).
The data is not in a format that excel can easily parse into a pivot
table directly from the source - it requires some formulae in excel to
be able to use a pivot table.
I have used a pivot table on each of those sheets to summarise the
data, and that works fine.
However, I would like to be able to get a single summary pivot table
from the two sheets (or from the two pivot tables).
Is that possible, and if so, how do I go about it?
"Alan" <...delete ghost spaces
Got this code....
Doesnt always work for some reason. Any alternate way to put this? (Or
is something wrong with it?)
Dim c As Range
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each c In Range("G2:T1500")
c = Replace(c, " ", "")
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
I'm going to guess some of your spaces are non-breaking spaces (usually
acquired from webpage text), so try using this line of code i...How do i keep the colors applied to the specific rows when sortin.
I have applied specific colors to specifc rows, but when i sort the colored
rows follow the sorting format.
...deleting duplicate rows
I have an import file that might have duplicates that I don't want to deal
with. I'm creating a temp table from the import file and want to delete the
duplicates from the temp table before proceding with other code.
Here's an example table:
create table #temp (itemnum int, firstname varchar(10), notes varchar(50))
insert into #temp (itemnum, firstname, notes) values (1, 'keith', 'some
insert into #temp (itemnum, firstname, notes) values (1, 'keith', 'some
insert into #temp (itemnum, firstname, notes) values (2, ...How do you define a custom paper size in Excel? (i.e. 11x17)
How do you define a custom paper size in Excel? (i.e. 11x17)
Excel doesn't provide for custom paper sizes, but most any size appropriate
for Excel output is already provided _if_ the installed print driver supports
it. Go to File>Page SetUp--Page and open the list of sizes. If your installed
driver supports 11x17 it will be in the list (although it may be listed as
'Ledger' rather than by dimensions).
"Marcin Rembisz" wrote:
> How do you define a custom paper size in Excel? (i.e. 11x17)
...Customized Task Views Have Disappeared (Take 2)
I was having an issue similar to this original post and followed the
given. It worked, but as I have worked with it I have found that it will
restore my customized Task views but not my customized Contact views. I can
change some of the Send and Receive setting and it will restore the Contact
views but not Task views. Somehow I am searching for a way to restore both
Task and Contact views. Any ideas?
Tia, Education and Documentation Specialist
Sorry, i posted this in the wrong discussion group. I have posted this
correctly and my question has been answered.
...Resize rows in a protected sheet
Hi there. I'm sending out a protected worksheet with some
cells that the users can enter variable amounts of text.
I've set the size so they can comfortably fit in about 50
words but I'd like them to have the flexibility to resize
the row height when they're editing the worksheet. But
because it's protected, they can't.
Is there anyway I can allow them to change the row height
dynamically? A button or something??
A workaround. Format the alignment in the cell to Wrap
text. Users can Keep entering text or returns (ALT+ENTER)
in the cell and it will aut...Max Row Height not long enough to print
How can I have text in a cell that is longer than the maximum row height
You can use a text box from the Drawing tool
Regards Ron de Bruin
"Dee" <Dee@discussions.microsoft.com> wrote in message news:9531E0F9-61F8-4226-9459-2478595CE814@microsoft.com...
> How can I have text in a cell that is longer than the maximum row height
> (409) print?
The only problem is that most of the cells will have this problem. :)
"Ron de Bruin" wrote:
> Hi Dee
> You can use a text box from ...Autofit rows
I am having an issue with autofitting rows in a spreadsheet of imported text
in Excel 2003. There are no merged cells in the document, and none of the
cells go over the 1024 character limit. When I select all rows and attempt to
autofit the rows to the contents of the cells, some of the rows resize
properly, and some leave one or several lines of white space below the bottom
of the text in the longest cell. I can resize them manually, but this is data
that is imported daily and runs to several thousand rows. If I widen the
column where I am having the problem, once it reaches a certain ...Deleting multiple rows through a formula
So does anyone know a formula that will allow me to delete multiple rows of
re-occuring data in a spreadsheet.
For example, I have a spreadsheet of 10,000 lines, with multiple mobile
numbers on it. I need to only have one of each mobile number and delete the
remaining rows where the mobile has been repeated?
you may be able to use the advance filter where can select unique records
select data filter advanced filter select copy to another location then in
list range box enter range to filter in the copy to box enter a free column
select unique records only then ok
then just ...Paste row under existing data
Hello to the group, this is the first time I'm here and I'm getting a
little desperate looking for a solution. I hope I'll find someone who
can help me with this. Anyone who helps me has a virtual beer from me,
cause this is rather urgent and I don't know how to do it. :-)
Okay, here's the deal. I'm using Excel 2000. I have a worksheet which is
used to enter different kinds of data (no kidding). When it's all
entered, it creates a row of 5 cells which needs to be copied to another
worksheet in another file for tracking purposes. Furthermore, it needs
to be done for...Creating Custom Dialog Boxex (Popup)
I am trying to create a custom dialog box that will allow me to have the
user clarify an entry when a checkbox is checked. I want them to be able to
select something from a list that I have created. I have created the popup
in Excel but cannot find out how to call the popup into the display when the
checkbox is checked. Can anyone help me please?
Is this a checkbox on the worksheet?
If yes, then if it's a checkbox from the Forms toolbar, assign this macro to the
Dim myCBX As CheckBox
Set myCBX = ActiveSheet.CheckBoxes(Appli...Copying non-adjacent columns to adjacent rows
Hi all, I consider myself fluent in Excel, but I've developed a situation
that has stumped me. Any help would be much appreciated.
I might be able to solve this issue if somebody could show me how to add a
number to a column. For example, if I want Excel to pull data from Column
D, how can I get Excel to realize that column D is really the same thing as
Column A + 3? I know you can use the column() command to get the numerical
value for a column, but is there a way to have it do that in reverse, such
that you could tell it the column number is 4 and it would know that you are
I've a field in my form called SR where users should copy a serial number
and paste it in this field,I'm worried because some users copy space at the
end or at the beginning of this serial,is there a way to make sure that users
input this serial without spaces?
Ini the AfterUpdate event of the text box, put code to remove all of the
Private Sub SR_AfterUpdate()
Me.SR = Trim(Replace(Me.SR, " ", ""))
Alternatively, you could put code into the BeforeUpdate event to make them
retype it if they haven't done it correctly:
Priva...how do I get rid of the automatic 2 spaces after every period
when i am in Excell and i put in 1.29 it always comes out as 1. 29
it does this is Word as well when ever i use a period anywhee it always puts
2 spaces in. if i go ... i get . . .
>when i am in Excell and i put in 1.29 it always comes
out as 1. 29
>it does this is Word as well when ever i use a period
anywhee it always puts
>2 spaces in. if i go ... i get . . .
Sounds like it could be a keyboard problem. Does it do
this in Notepad or any other application where you can
"squarelock" <s...Adding Row an keepin correct SUM
This a reverse of my previous question.
I have the following;
If I delete the row with 10% and later
wish to add a row after the formula,
the formula does not recognize the
new row. Is there a way to do this?
On Mon, 25 Oct 2010 at 12:09:33, Gianni <email@example.com> wrote in
>This a reverse of my previous question.
>I have the following;
>If I delete the row with 10% and later
>wish to add a row after the formula,
>the formula does not recognize...How to get more than 65000 rows in and excel spreadsheet
I am importing data into an excell spreadsheet that has 100,000 + records,
how do I expand on the 65,356 record limit that I see in Excell?
Wait for Excel 12! Over 1,000,000 rows, Seriously, there's no way to expand
this. It's fixed in stone and is always 65536. However, you can read records
in thru VBA code and break it onto new worksheets when you reach the limit,
but NOT by doing File/Open.
"Jake Clark" <Jake Clark@discussions.microsoft.com> wrote in message
> I am importing data into an excell spreadsh...How do i insert symbol in custom footer
I'm working on Excell 2003
I've been asked to create a custom footer in the left column i have to
insert Copyright © 2003.
I can't figure out how on earth to insert the symbol if anybody out ther
knows could you please let me know
one way is to use Insert | Symbol and select the � character and copy it
before you go to View | Header and Footer. Then just use Ctrl-V to paste it
in the Footer
"Den" <Den@discussions.microsoft.com> wrote in message
> I'm wor...