A replacement for about-to-be-closed NGs
To those of us who, for whatever reason, are still using "unsupported"
technologies, these news groups are a valuable resource. The quasi-related
forums to which Microsoft has invited us are hardly replacements, posts
'classic' technologies will be OT, and I'm sure pretty much everyone who
posts questions about them would rather see responses more meaningful than,
"consider upgrading to [something that is still supported]."
In hopes of filling the void that will be left by these pending closures,
I've added a section to a forum I...Replace cell letter
Not sure how to explain this, but im looking to save a lot of manual entry.
ie. sheet1 is fetching its data from sheet2 A1:A1000 and displays the data
all over sheet1 to many different cell positions in different columns/rows.
How do I point to new data from sheet2 B1:B1000 by replacing all the cells
"=+Sheet2!A####" to "=+Sheet2!B####" in sheet1 while keeping the same cell
positions??? Hope it makes sense...please HELP!
Try Ctrl+H to launch Find and Replace dialog..Make sure you select 'Formulas'
&qu...Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...Using custom fields for better email list view.
I get lots of letters with the same title. I want to group them by topic and
sort on the number of letters in the group. I know that I can do this using
custom fields but I do not know what query to use to get the number of
letters the group.
...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...Exch2003 and custom Outlook forms
I have a user who created several forms in their Outlook (Office
2003). Now, they want to share these forms. I need to move the forms
into Exchange 2003, running on SBS 2003. Manually copying the forms to
a public folder appears to only transfer data, so my question is this:
What is the best method for publishing a form from Outlook 2003 into
Exchange 2003 Public web folders?
Thanks in advance,
J Wolfgang Goerlich
D�j� Ak�m�l�f�, MCSE MCSA MCP+I
Do you now realize that Today is the Tomorrow you were...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <email@example.com> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...GAL issue
Our existing Exchange 5.5 organization consists of two different sites,
each in its own NT 4.0 domain, so call that siteA and siteB in domainA
and domainB for simplicity. They share a common GAL between them as
you would expect and all is well.
I've just installed the first Exchange 2003 server in a Windows Server
2003 AD domain (call this domainC) and placed the Exchange server into
Trusts are in place between domainA and domainB (previously), between
domainA and domainC (for the migration), but not yet between domainB
The problem that I see now is that GAL for use...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...Making a compiled list in Excel
I'm trying to create an Excel spreadsheet that can create a compile
list from an existing list. By this I mean there is a list of item
which represents the complete list and each entry has a checkbox nex
to it to indicate whether it has been selected or not, and then on th
same worksheet there is another list which only contains the items tha
have been selected from the first, full list.
Check out these screensheets to get a better idea of what I mean:
I think this should b...REPOST: Contacts/Global Address List/Automated Dialling
We can currently initiate telephone calls from within our contacts folders,
plus some public (contact) folders, by right-clicking and selecting Call
This feature could use our mobile phones (via Bluetooth) but more usually it
uses our BCM office phone system. This all works fine.
However, under this system we are maintaining a lot of duplicate data: 1 x
Active Directory, 1 x Exchange 5.5 directory, and several public contact
We are moving to Exchange 2003 soon which will mean that Exchange will
directly tap into AD, rather than maintain it's own directory. We would als...Cannot add columns to custom views
I have a problem that is causing a major handicap.
I cannot add any columns to any custom leads view that I create. No matter
what, the only column that is displayed is the default key column (name) that
is there when the view is created. When I click on add columns, the dialog
box that is supposed to list columns that I can add to the view has no
columns listed at all.
I am logged in as the System Administrator when trying to accomplish this.
Also, when I create a filter criteria it is never saved. I save it, but
when I go back into it, it is gone.
Any help would be GREATLY apprec...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...Customizing the New Mail Form
Hello - I have a few quick questions about customizing the new mail form. I
have put some user defined fields on the New Mail form which I'm integrating
with my application. I'm wondering if there is a standard method of
inserting a header in the body of all Emails (such as one's letterhead) and
how this is done.
How long does it usually take for my post to get to google? It seems as if
I'm seeing my question below in my Outlook Express (which I just started
learning how to use) but it is not yet on google and it has been a few
I have an XML file:
<Key Name="Setting1" Value="101"></Key>
<Key Name="Setting2" Value="202"></Key>
<Key Name="Setting3" Value="300"></Key>
<Key Name="Setting4" Value="404"></Key>
I want to change the value of "setting3" from "300" to "303."
Can somebody provide me with code that will allow me ...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <firstname.lastname@example.org> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the
> OLEMISC_INVISIBLEATR...control box list
Hi I have a long list of hospitals, and would like to put a control in
that will fill in as you type to search.
I have tried list box, but can not see how to enter the list into the find
...Hiding plot Area
I have a formatted output sheet that has a Pie Chart
embedded. The data for the pie chart comes from a second
sheet using 2 ranges B2:B6 & D2:D6 B2:B6 is always
populated and contains labels. What I want to do is, when
D2:D6 contains 0 in each cell (or Null), suppress the Pie
chart but always show the Legend (which is driven by B2:B6)
All you see of the pie when all values are zero is a single line at the
first slice. The legend still appears. To hide the line, double click on
one of the wedges and on the Patterns tab, change the Border setting to
None. ...Replace the minus value
I am working in one sheet. There are some negative (minus) value in some
cell. I want to replace it with zero with the use of formula.
Kindly suggest me, how can it possible.
To use a formula:
"Rajiv" <Rajiv@discussions.microsoft.com> wrote in message
> Hi freindz,
> I am working in one sheet. There are some negative (minus) value in some
> cell. I want to replace it with zero with the use of formula.
> Kind...Click on list Item and open a Detail form
I need help withe the following: I have a form that has a listbox that gets
its data through a query, the list box only show two colums: Company and
ProcessDate, also the query retrieves more fields but I set the width of the
columns to zero.
I also have a command button "CmdViewDetail" that on_click should open a new
form that will contain the rest of the information for the record I selected
on the list box.
How should I do this? I'm not very experienced with vba, could somebody help
> I also have a command button "CmdV...Hiding rows with VBA
In my sheet called "insertsheet I have this VBA:
(thanks to some users of Google groups)
Private Sub Worksheet_Change(ByVal Target As Range)
Const nMAX As Long = 10
Dim nRows As Long
Application.ScreenUpdating = False
If Intersect(Target(1), .Cells) Is Nothing Then Exit
nRows = .Value
.Range(.Cells(1, 5), .Cells(1, _
.Columns.Count)).EntireColumn.Hidden = True
.Range(Cells(1, 5), .Cells(1, _
I have data in cells A7:DK394 which all have 0 in them until totals are added
in other worksheets which then pullthrough.
At the end of the week I have to Hide all rows from A7 to A394 that still
have 0 in them as no totals have been added in other sheets so the customer
has not posted with us.
is there any way excell can recognise the cells that have no data against
them and hide them automatically by pressing a button. or if they all start
off hidden unhide as data is entered.
Hopefully this makes sense
many thanks for any help with this as again its to save me lots of...How do I hide email addresses in outgoing mail
Hint: You post your question in the body of the post, not the Subject.
Hint 2: Use the BCC field.
"Dennis" <Dennis@discussions.microsoft.com> wrote in message
"Dennis" <Dennis@discussions.microsoft.com> wrote in message
PLEASE write your question in the body of the post and NOT just the subject
Have a look here: http://dts-l.net/goodpost.htm
As posted here MANY MANY times - put them in the BCC...