Different Users, Different Levels Of Views

Nov 22, 2006

Right now, I've this pop up box which prompts users for passwords and user name for log in. They are two main users : Admin and User. Admin is the user which is allowed to see all sheets. While User is only restricted to user interface sheets.
The problem is for the "User" I want to restrict a view in the sheet
"ELEMENT". I wish to hide columns L to AI if "User" logs in. But if "Admin" logs in, I want no columns hidden. Everything must be visible.

Private Sub CommandButton1_Click()
Sheets("Main").Select
Dim strUser As String, strPword As String, strWs As String
Dim w As Worksheet, c As Range, r As Range
strUser = Me.TextBox1.Value
strPword = Me.TextBox2.Value
Select Case strUser
Case "User"
If strPword = "User" Then
Sheets("SMXINVENTORY").Visible = xlSheetVisible
Sheets("SMVINVENTORY").Visible = xlSheetVisible
Sheets("SMIINVENTORY").Visible = xlSheetVisible
Sheets("SMF1INVENTORY").Visible = xlSheetVisible..............

View 3 Replies


ADVERTISEMENT

ComboBox - VBA - Unique Views...

Jul 11, 2009

I have a column that is updated several times a day, I need to be able to view that list in a userform combo box and that box to be able to react like an autofilter list. I've tried the advanced filter thing but as th elist is contantly updated it makes this very hard to handle as I have to set macros to compile the list and then delete it once it's been used. Is there a way I can set vba code so the ComboBox populates unique fields, sorted AZ and removed the blanks without using the advanced filter..?

View 7 Replies View Related

Multi Views On Same Worksheet

May 20, 2013

Is there a way to have 2 views of the same sheet that will enable either user to only see their own requirements (columns, row)s but that will update the overall worksheet. The users would not be accessing simultaneously. Complex sheet so just need to have user access to a subset of data.

View 1 Replies View Related

Pivot Table 'views'

May 11, 2008

I have a very complex data source (80 columns, thousands of rows) and need different types of Pivot tables for analysis. I have created around 20 Pivot tables in different sheets based on the same data. What I wanted to know was, is there something like a saved 'view' which I can select in the Pivot table to generate different pivots in the same sheet (with different settings of rows, columns, etc but based on the same data)? Currently, to view the other Pivot, I have to go over to the other sheet - or customise the current pivot.

View 9 Replies View Related

Turn Off Custom Views

Apr 19, 2007

I'm dealing with a spreadsheet that uses custom views. Before I do anything with it, I want to make sure that there is no custom view enabled (e.g. just display all). I've tried Chip Pearson's ThisWorkbook.CustomViews("View1").Show suggestion, but it just throws "Runtime Error 5: Invalid procedure call or argument". My actual code is: ThisWorkbook.CustomViews("All (Est)").Show

View 7 Replies View Related

Run Custom Views From Worksheet

Jun 8, 2007

I setup custom views for my worksheet

I dragged the custom view command to my menu bar

Everything works great on my machine

But I would like to send to other users and for them to be able to use the custom views w/o having to help them setup on the menu bar

Plus I've had problems in past where custom view tool is not persistent on the menu bar
Sometimes there, sometimes not

Is there a way to add to say cell A1 on the worksheet instead?

View 3 Replies View Related

Print One Worksheet In Different Filtered Views As One PDF?

Jan 18, 2013

I have a worksheet set up with a number of pivot tables to show job summaries for each project manager. I created buttons labeled with each project manager that trigger a macro to filter the results to only show jobs for that specific project manager. There's one button for each project manager.

I'd like to create a macro that will essentially show each project manager's report and compile the result into one PDF. I only have 5 project managers so I don't need an array or anything if that makes it easier, I could write the code manually for each one.

So basically, it would do this:

1. Run macro to filter results to only show Project Manager #1 jobs.
2. "temporarily" print to PDF.
3. Run macro to filter results to only show Project Manager #2 jobs.
4. "temporarily" print to PDF.
5. Run Macro for Project Manager #3, etc.....
...............
Final step. Compile all the "temporary" pdfs into one file.

View 2 Replies View Related

When Using Custom Views - Get Error Message

Aug 13, 2014

I have created a report with 22 sheets as different pages to be included or hidden depending upon the type of report needed. I had found several sources saying to use the Custom Views function. So for example I will unhide all the sheets and add as a Custom View "All Sheets" and then whittle it down to the 5 I might need for B type inspections and add that view as B Inspection. But when I try and toggle between them I'm getting an error message that says "Some view settings could not be applied" - and thew saved view I was looking for is not the same sheetwise.

View 1 Replies View Related

Shared Workbook Scrolling And Views

Oct 6, 2009

1. I have a shared and protected workboook that about 15 people update. For some reason, when people open it they can't always scroll. Anyone know why this happens and how to fix?

2. Is there a setting so that whoever opens the workbook will see the same view (instead of whatever view the last person saved the file in)?

View 10 Replies View Related

Use Checkbox To Control Custom Views?

Sep 14, 2012

I am trying to use a checkbox to control the custom views that i have set ("Normal", "Hide") However after i entered it in VBA, it just does not work. After i check or uncheck the checkbox, it just keep going back to the "Normal" view.

Sub CheckBox1_Click()
If CheckBox1 = True Then
ActiveWorkbook.CustomViews("Hide").Show
Else
ActiveWorkbook.CustomViews("Normal").Show
End If

End Sub

View 5 Replies View Related

Query SQL 2005 Views With Excel

May 20, 2009

I've posted this on Experts Exchange too, specifically trying to target the SQL Server experts. http://www.experts-exchange.com/Soft..._24423637.html


SQL Server isn't really my thing. I have been asked to quote on a job to build some models. One of the components is to pass parameters to sql server views and return the data into a table in Excel. I never done this.

1. Is it possible to pass parametrs to a view thru Excel?
2. Will the view execute based on the users permissions (different users using the Excel template have different access rights)?
3. Any other things to consider?

I don't need specific solution, only really some broad advice. I really only want to know how feasible this is...

View 9 Replies View Related

Force GetOpenFilename To Views - Preview

Nov 4, 2006

I copied below code from one of Andy Pope's thread answers. Thanks Andy.

Private Sub CommandButton1_Click()

Dim vntFile As Variant

vntFile = Application. GetOpenFilename("Graphics Files (*.bmp; *.gif; *.jpg; *.jpeg),*.bmp;*.gif;*.jpg;*.jpeg," & _
"All File (*.*), *.*", Title:="Select Picture")

If vntFile <> False Then
ActiveSheet. Cells(27, 1).Value = vntFile
Image1.Picture = LoadPicture(vntFile)
Image1.PictureSizeMode = fmPictureSizeModeStretch

End If
End Sub

I would like to force the box to open in Views - Preview instead of List or Details or whatever it is at. I tried the following (and a bunch of other things), but I could not get it to work

With FileDialog
.InitialView = msoFileDialogViewPreview
End With

View 9 Replies View Related

Custom Views Lost After Cut/Move/Insert Etc

Aug 26, 2006

I have a large spreadsheet that I am managing and there are many users who access this for information. Because of this, we have all created "custom views" for our departments.

I continue to struggle with how to save changes in these custom views. Yesterday, I added and moved some columns to the spreadsheet and now all the custom views are messed up. The only way we have been able to work through this is deleting and creating new views.

View 9 Replies View Related

Show/Hide Specific Columns For Custom Views

Jun 12, 2008

I have a spreadsheet with four columns of data for every month (i.e. January has a Prior Year, Budget, Outlook, and Actual column). I have been trying to come up with a macro or form that will allow me to customize which columns I would like to see and hide the rest. For example, if I chose to see the Budget and Actual columns, it would hide the Prior Year and Outlook columns for each month.

View 2 Replies View Related

Stock Levels

Mar 27, 2008

how to go about actually doing it,

For an old project which was a till system i had two sheets,a data sheet and till system sheet , the data sheet contained :

example:
column A - numbering of the data (to be used with V Lookup)
column B - product name
Column C - price

This would then be replicated in the next 3 cells for the next data category.

Till system then had a combo box which had a cell link on the current page and data from the data sheet and then i had a price column next to i (containing V Lookup formula) the price then changed depending on the choice in the combo box.

I want to incorporate combo box's in to this new project. If i can then get some kind of stock thing i intend on then using conditional formating to colour code stock levels to show severity of needing to order etc..

View 14 Replies View Related

Too Many Levels Of Nesting For Formula?

Apr 3, 2014

Im recieving an error saying that i have too many levels of nesting for my formula

Is there any way to rewrite the formula i have here?

=if(I1>99,0.5,
if(I1>89,0.45,
if(I1>79,0.4,[code].....

View 3 Replies View Related

IF Command - Too Many Levels, Alternative?

Sep 15, 2009

I am trying to use the command below to report what type of bonus is to be awarded. .05% - 1% bonus, commission based.

=IF(E7>=0.12,1,IF(AND(E7>=0.115,D11<=0.1199),".09",IF(AND(E7>=0.11,E7<=0.1149),".08",IF(AND(E7>=0.10 5,E7<=0.109),0.07,IF(AND(E7>=0.10,E7<=0.1049),"0.06",IF(AND(E7>=.095,E7<=.099),".5",IF(AND(E7>=.09,E 7<=.0949),".04",IF(AND(E7>=.085,E7<=.0899),".03",IF(AND(E7>=.08,E7<=.08499),.025, IF(AND(E7>=.07,E7<=.0799),".15",IF(AND(E7>=.065,E7<=.0699),".005")))))))

It is telling me there are too many levels. I am not an Excel expert, so I am trying to figure out an alternative to this command, I am sure one is available.

View 5 Replies View Related

Have Two Levels Of Subtotals In Spreadsheet?

Oct 9, 2013

I have a report of employees' hours reported for the week, which I process payroll from.

I have sorted the spreadsheet first by employee number, and then by date. I have subtotaled each day's hours (with a formula rounding each day's hours to the nearest quarter hour).

I now need to add a subtotal of weekly hours, per employee number, and I cannot figure out how to do this.

Here is an example of what I want to do. I have highlighted the second subtotal I want to add to the spreadsheet, but have been doing the =sum(xxx) formula for each employee because I can't figure out how to subtotal again.

David L 9/30/2013 0005 360 6:00 A.M. 12:00 P.M.
David L 9/30/2013 0005 112 12:30 P.M. 2:22 P.M.
David L 9/30/2013 0005 115 2:22 P.M. 4:17 P.M.
David L 9/30/2013 0005 13 4:17 P.M. 4:30 P.M.

[Code].....

View 2 Replies View Related

Pivot Chart Grouped At Two Levels

Aug 21, 2012

I have daily data that has columns for day, day of week, week end, month, year. I am trying to create a pivot chart that displays the data as a line chart day by day and as a secondary axis column chart by week.

View 1 Replies View Related

Pivot Tables Design With 5 Levels

Jun 24, 2014

How can I format a Pivot Table with 5 levels. I try to use the "Design" but it only format the first 2 levels of the Pivot Table. I need to distinguish each level with different colors. I think manually is a bit difficult.

View 6 Replies View Related

Convert Levels To Numerical Values

May 29, 2009

I need to convert levels to numerical values and then: Firstly, add together two vlookup values THEN divide by 2 to get an average AND THEN see if this average AND a second, individual lookup value are above a specified another value, which may be different. IF all these criteria are set, return, "yes" if either the first or second, or both criteria are not met then "no"

Or put it another way. if lookup values A+B/2>"5" AND C>"3" then "yes", Else "no"

Lookup chart:

P11
P22
P33
P44
P55
P66
1c7
1b9
1a11...............

View 3 Replies View Related

Collapse All Levels In Pivot Table

Sep 9, 2010

I created a PivotTable that works fine. A user can click on an option and the subcategories expand; then he can choose one of those and a new group opens, etc., going 4 or 5 levels deep in options.

What I need to do is: If he then wants to start over and choose another option in the initial level, I want all of the subcategories to reset to their original closed state (unexpanded). As it is now, when he goes back to the original choice, that is closed, but everything inside it is still open as he had selected them previously.

View 6 Replies View Related

Formula For A Sum When Multiple Levels To Choose From

Feb 20, 2014

How do I enter a formula to find a dollar amount for a different range dollars? For example, if $0 - $1000 = $50 and $1001 -$2000 = $100. In reality, I would like to enter a specific dollar amount within one of the levels (column 1) and the sum (column 2) would auto fill.

$0-$1000
$50

$1001-$2000
$100

View 5 Replies View Related

How To Get 14 Visible Levels Of RED For Conditional Formatting

May 25, 2014

I have a 14 step Lead Generating process and I want to color code each step as a level of how hot it is by where it is in the process but I cannot get 14 different reds.

When setting it up I went to More Colors, then Custom and changed the Color model to HSL and all I got was White with White borders.

I have tried to pick 14 reds from the standard colors but the difference is not very noticeable.

View 2 Replies View Related

Solver With Constraints For Inventory Levels

Nov 9, 2008

I have a maximization problem. I have to maximize Kitchen Sets given available materials. I have 11 different Kitchen Sets and every set requires different material.I have attached an excel spreadsheet for making the problem more clear.

I have T1;T2;T3;T4;M1;M2;M3;M4;O1;O2;O3;O4;Z1;Z2;Z3;Z4 different materials. Every kitchen sets requires one material from T which is fixed (for example T2), one material from M which is fixed again (for example M3), one material from O which is fixed (for example O1) and one material from Z, which is fixed (for example Z4).To complete a set the sum of all materials used should equal to 4. I have some constrains T1+T2+T3+T4<=2 it is the same for M1+M2+M3+M4<=2, O1+O2+O3+O4<=2 and Z1+Z2+Z3+Z4<=2.

So basically my goal is to say which materials should I keep in stock in order to maximize the Kitchen Sets.

View 9 Replies View Related

Workbook Password Protect 2 Levels

Jan 22, 2007

On opening a workbook (XL2003) I want users to enter a password which will give them read Only permissions or access to the whole book. I do not want use the "save as" option it is not suitable for my needs & here is why. I have about 10 staff who need to fill in timesheets using XL SS on a public folder on the server. The staff need full access to file & management such as myself only need to view (read only) the timesheet without the ability to change data. Using the "save as" function the staff need to input 2 passwords.

The staff (in general) are not overly computer literate so I was hoping to be able to write code so that on Workbook_Open event only one password is entered and depending on the password gives the user full access or readonly access. This will also save management having to remember different passwords for read only access to different staff timesheet files & will give crude protection to the files.

Private Sub Workbook_Open()
Dim Message, Title, Default, Password As String
Message = "Enter your password" ' Set prompt.
Title = "Password" ' Set title.
Default = " " ' Set default.
' Display message, title, and default value.
Password = InputBox(Message, Title, Default)
If Password = "test" Then
Workbook.ReadOnly = True
Else
Workbook.ReadOnly = False
End If

End Sub

Error occur on "Workbook.ReadOnly" lines . I also want to put an errorchecking code for invalid passwords. Again, I know I can use the "save as" option but that is not what I need.

View 7 Replies View Related

Autonumber/highlight Stock Levels

Apr 9, 2007

to create an order ID so when customer is transferred from the new order to Existing orders it will automatically generate CUW001 for first order then CUW002 for the second order and so on I have added a column form Order ID so this may have affected the macros pasting location. Also one last thing could you also tell me how I could highlight stock items red if the stock levels fall below 5

i have attached the spreadsheet

View 4 Replies View Related

Show Different Outline Levels Of 2 Groups

Mar 19, 2008

I have two groups (outlines) of columns on the same sheet. the following line :

ActiveSheet.Outline.ShowLevels 0, 1

controls the two groups. What if I want different levels od detail for each group ?
TIA.
Daniel

View 2 Replies View Related

Collapsible Rows & Column With Different Levels

Mar 19, 2008

I have been using a spreadsheet which will allow you to hide columns and rows with a button associated with that row or column. I need to adapt this spreadsheet for another purpose but dont know how to recreate this feature. I have attached a screan capture to assist with my description

View 2 Replies View Related

Formula Is Returning Msgbox Too Many Levels Of Nesting

Mar 31, 2009

I have the following formulas which when I try to put in excel, it says I have too many levels of nesting:

=IF(K4="","",IF(AND(Hta_1>=D4,Hba_1<=D4,Hta_1<>"",Hba_1<>""),1,IF(AND(Hta_2>D4,Hba_2<=D4,Hta_2<>"",H ba_2<>""),2,IF(AND(Hta_3>D4,Hba_3<=D4,Hta_3<>"",Hba_3<>""),3,IF(AND(Hta_4>D4,Hba_4<=D4,Hta_4<>"",Hba _4<>""),4,IF(AND(Hta_5>D4,Hba_5<=D4,Hta_5<>"",Hba_5<>""),5 ,IF(AND(Hta_6>D4,Hba_6<=D4,Hta_6<>"",Hba_6<>""),6,IF(AND(Hta_7>D4,Hba_7<=D4,Hta_7<>"",Hba_7<>""),7," No reinforcements"))))))..........

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved