Bill, getting a user login name from a Windows computeris the real easy bit.
In the macro I use: dbuser = Environ("username") where dbuser is the
variable assigned to the environ function. I then use dbuser in a lookup
function. The custom view does not work for what I am trying to do. Basically
I have a whole bunch of people on a roster, and depending on who accesses
this roster decides how to display the people. For instance group all the
trades together, then group all the technical together. When Admin access the
roster the columns with the names in would be grouped Left to Right
alphabetically. Try cutting and then inserting a cut column into a differnt
Col(say from D1 to A1) and then save that view. When you try to show that
view from the default view it does not work. I don't want to hide columns,
just re-arrange them depending on the user login.
--
Steve F


"Bill Kuunders" wrote:

Not sure how you are going to tell the system the login name.
But the custom views should work.

I start with naming the normal view.........
You would then need to hide the columns and add a new view name.
make sure to keep the "hidden rows ,collumns etc"selected

To re-call the views with a macro instruction use:
ActiveWorkbook.Customviews ("yourname").Show

--
Greetings from New Zealand
Bill K

"Steve F" wrote in message
...
I have a spreadsheet with 30 coloumns. Differnt users access this
spreadsheet
and depending on their login name I wanted to display a different layout
for
differnt users. I have tried using custom view but it does not work. I
tried
cutting and inserting the cut colomn into a differnt part of the
spreadsheet
and named the custom view, but it did not go to it from the default
layout.
In other words it appears you cannot use custom views to view different
layout options
--
Steve F