Filter/Display only certain rows of information based on a user na
I have a spreadsheet that contains a list of employee names (In Column "A")
and information across a row related to them....Each employee is under 1 of 4
managers and what I need to do is have a way for the manager to log into the
spreadsheet and only display the employees that is under them.
Thank you in advance for your help,
Is the exclusivity down to confidential data or is it just to make it easy
for the Managers to see their own staff?
Is there a column that contains the Manager's name?
If so and if confidential matter is not a p...How do I set up group emails from specific account contacts?
"GLOVE GUY" <GLOVEGUY@discussions.microsoft.com> wrote in message
> Big Tex
Hi am still stuggling with setting OWA up on my 2003 exchange box. Can
someone with Exch 2003 check a few settings in IIS for me so I confirm it is
When I try to connect via the lAN (for testing purposes) it says access
denied. Here are my settings:
Default web site is set to anonymous access.
Exchange virtual directory is set to Integrated and basic.
I have no SSL applied to the site.
One thing I have noticed is the defaut application pool is stopped could
someone please confirm this is the correct setting. The exchange application
pool is running.
I am really strugg...How do I set up an automatic delete or move of a row of data?
I have a job summary that lists the status of my projects. I want to move
the data and close up the gaps in the spreadsheet as I change the status to
You need to provide more information. For example, how do you change the
status to complete and where do you want to move the data to?
> I have a job summary that lists the status of my projects. I want to move
> the data and close up the gaps in the spreadsheet as I change the status to
I have a list that identifies the "status" of th...Setting up News Groups
How do I set up Newsgroups using Outlook 2007?
> How do I set up Newsgroups using Outlook 2007?
You don't. Grab a copy of, say, Thunderbird and use that just for
Newsgroups. If your ISP allows feeds of Newsgroups set it up through
them in Thunderbird. Otherwise sign up for one of the free ones, like
Motzarella and set up the Groups from within Thunderbird, using
Motzarella.org as the News provider. No need to use Thunderbird for
anything but the Newsgroups, if that is your fancy.
Of course you coul...how do i keep adding to existing total in same row
i want cells a & B to be incoming and out going numbers and cell c to total
accordingly. i have that part but want a & b cells to be reinputted band
total change with new inputs so that total continues to grow or shrink with
each new imput want to reuse same a & B cell agian and agian
Microsoft MVP - Excel
"marklessexcel" <firstname.lastname@example.org> wrote in message
>i want cells a & B t...CListCtrl Header height change??
CListCtrl Header height change??
Is it possible to change the height of a CListCtrl Header.?
...how do i set outgoing server different from incoming server?
the server i use to receive email is panhandle.rr.com. at home, my internet
connection is provided through charter calbe though. i set up my email in
outlook and can receive emails but i can't send any emails. they all come
back with the message "undeliverable" through the online help topics, it
says i need to setup my email account with different incoming pop3 and
outgoing smtp addresses, but it doesn't explain how. please help!!!!
What version of Outlook are you using?
"karebear" <email@example.com> wrote in message
news:...Problems with CListCtrl
I'm having trouble with a CListCtrl object. I'm trying to automatically
set the selected items of the list from my code. I try the following
m_List.SetItem (pos, 0, LVIF_STATE, NULL, 0, LVIS_SELECTED, LVIS_SELECTED,
The SetItem function returns non-zero, which supposedly means it was
successful. However, I don't see any selection showing up. I even called
RedrawItem on this list item, but it didn't help either.
Anyone know about this?
>I'm having trouble with a CListCtrl object. I'm trying to automatically
>set the selected ite...The code below worked for a few days and just totally stopped working.
The code below worked for a few days and just totally stopped
What can I do to make sure it continues to work? Thanks!
Private Sub Worksheet_Change(ByVal Target As Range)
Dim C As Range, D As Range
Set D = Intersect(Range("A:A"), Target)
If D Is Nothing Then Exit Sub
For Each C In D
On Error Resume Next
Target.Offset(0, 6).FormulaR1C1 = "=RC[-2]&RC[-5]" ' - For Column E
Target.Offset(0, 7).FormulaR1C1 = "=RC[-2]&RC[-5]" ' - For Column F
Target.Offset(0, 9).FormulaR1C1 = "=IF(ISNA(VLOOKUP(RC7,I.O.!
R2C1:R57...CTreeCtrl and CListCtrl problem
I use create a single document struct using MFC(explore
style).The left of the window is CLeftView class(which
inherit CTreeView).The right is CBrowserView which inherit
CListView.I want to display the content of a directory in
the right(CListview) when user click the item of the
In the LeftViw I add method "void CLeftView::OnClickItem
(NMHDR* pNMHDR, LRESULT* pResult)" because I want to know
which item be clicked by user.
data=mtree.GetItemDat...CListCtrl and sub item editting
Is it possible to implement CListCtrl sub item editting without creating a
I am using VS2003.
>Is it possible to implement CListCtrl sub item editting without creating a
There's no built-in support for this, so no, you have to provide some
implementation for this. Have a look on sites such as CodeGuru and
CodeProject, they'll have examples.
I've seen examples, I just wasnt sure if I needed my own ctrl.
"David Lowndes" <DavidL@example.invalid> wrote in message
news:k...Visual Basic code for macros
I'm trying to write a macro to transfer new data from one sheet in a workbook
to another. To do it I need to navigate from the active cell to others by
using the active cell as a reference point and moving by "R[+n]C[-x]" rather
than by a specific cell address (eg H4) referenced from the top left corner.
Is there a way I can get a useable return from the ActiveCell function, or
any other code structure that might give me the result I'm looking for?
I'm using Excel 2002 and Visual Basic Version 6.3.
maybe you could use
Derek...XML from file to code
I' reading an xml file from an external location
the encoding: <?xml version="1.0" encoding="iso-8859-1" ?>
My problem is, when I read the data from the xml element with
element.firstchild.value, some special characters disapear.
element.firstchild.value returns abc
the special char "�" is gone.
> I' reading an xml file from an external location
> the encoding: <?xml version=3D"1.0" encoding=3D"iso-8859-1" ?>
> My problem is,...How to add clistctrl into clistctrl?
How to clistctrl into a clistctrl? For example like adding checkbox ,
combobox, i want to add clistctrl into a clistctrl
...Inserting a Row Every "X" Rows
Does anyone know how you might go about inserting a extra row inbetween rows at certain intervals. For instance, auto insert of rows every 3rd row, etc.
Application.ScreenUpdating = False
Dim numRows As Integer
Dim R As Long
Dim rng As Range
numRows = 3
Set rng = ActiveSheet.UsedRange
For R = rng.Rows.Count To 1 Step -1
rng.Rows(R + 1).Resize(numRows).EntireRow.insert
Application.ScreenUpdating = True
Regards Ron de Bruin
"JMS" <firstname.lastname@example.org> wrote in me...Write record from Form to new row in spreadsheet
I am using a form to provide input into a spreadsheet. Every time I write a
record, I want it to write to a new line in the spreadsheet. When I first
used this code, it wrote on the second line in the spreadsheet, even though
there was a second header line there and it overwrote the line. When I took
out the first header, it wrote on the second line okay. However, when I tried
to enter a new record, it overwrote the first record.
Basically I want to write the first new record on the third line (after two
header lines) and then each new record on the next available line, etc. Be...Setting up a Metrologic Stratos 2320 with POS 2009
Has anyone connected a Stratos 2320 (Scanner-Scale) with Microsoft Dynamics
POS 2009. And if you have can you please provide the steps you used to
Problem solved: The Stratos 2320 come out of the factory as a dual cable
connection and if you get a single cable connection you will need to follow
Honeywells instructions to change the configuration. So if any one needs
this PDF document please let me know and please provide me with your email
address and I will send it to you.
> Has anyone connected a Stratos 2320 ...How do I set all folders automatically to DETAIL view?
How do I set my computer so that all folders, subfolders, etc. open in DETAIL
view automatically instead of SMALL ICONS? I am very tired of having to
change the view every day, every folder, etc.
Thank you for your assistance.
And, shouldn't it be easier to find this information in the system than
having to post to other uses or Microsoft staff? Just a thought.
Assuming Windows Vista: open any folder in your Windows explorer and set the
way you want all your folders to look. Press ALT to make the menu bar show
up. Then take Tools -> Folder Options -> View tab. Th...Flipping column and row headings #2
I need to flip the column and row headings.
Is this possible?
I think you should use the transpose formula, you highlight say the column
area A2:A11 and type =TRANSPOSE(B1:B10) and finish with Ctrl+Shift+Enter.
Give it a whirl...
> I need to flip the column and row headings.
> Is this possible?
...lead zeroes in zip codes
How do you do a spread sheet and maintain a lead zero in
the zipcode (example 08550 shows up as 8550)?
"fred rosenfeld" <email@example.com> wrote in message
> How do you do a spread sheet and maintain a lead zero in
> the zipcode (example 08550 shows up as 8550)?
Format the cell with a custom format 00000 and you will always see 5 digits.
In addition to Anon's 00000 custom format suggestion, there's also two
Zip code formats under Format > Cells > Number > Special. Plain
vanilla "Zip...: Delegation of setting Mailbox permissions...error
I have read the "Working with Active Directory Permissions in Microsoft
Exchange 2003.doc" and used the specific snippets to delegate the
creation of mailbox enabled user object in to a W2K3 AD/E2K3 SP1
I don't have full control on the users objects nor have I delegated
write all attributes on the user objects only a subset. Still I can
change every attribute related to the exchange information, so far so
The only problem I have is when setting the mailbox security.
Facility: LDAP Provider
ID no: 80070005
Microsoft Active Directory -...setting up Outlook #6
How do I set up outlook to send and recieve emails when I have AOL?
Sxybutterfly <Sxybutterfly@discussions.microsoft.com> wrote:
> How do I set up outlook to send and recieve emails when I have AOL?
AOL has instructions on how to do this.
...How do I set up foot page to print out the computer's name
How do I set up foot page to print out the computer's name
Private Sub Workbook_BeforePrint(Cancel As Boolean)
.LeftFooter = "Computer name: " & Environ("Computername")
'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code
(remove nothere from the email address if mailing direct)
"Bee" <Bee@...XP Forgets Display Settings After Restart
I have dual displays at my computer and it has recently started "forgetting"
the display settings after I restart. Upon restarting once, only one monitor
will come up with a signal and I can't get it to output to the other monitor.
If I restart a second time, both monitors will have a signal but it has the
wrong montior set up as the primary monitor. What is supposed to be my second
monitor (the one w/ my desktop extended onto it) has my desktop icons and an
extra toolbar that I use. It's also oriented on the wrong side of what is
supposed to be my primary ...