view

Hi all, First of all many thanks for all the good stuff on this forum! I'm using this forum for a while but can't find the answer to my problem this time, thanks for your help! In my macro to protect I use: ThisWorkbook.Protect Password:="BlaBla!", structure:=True, Windows:=True To unprotect...

Using Excel 2016, my file is set to open with 2 views. How do I change it to open in only 1 view (the normal way)?

Hi, For some reason my data is changing between Power Query and data view. My source file is a simple Excel table. I import this into Power Query without issue and the data looks exactly the same. However when I view the data in Data view in Power BI the data has changed from a certain...

Hi, I am looking for a formula that automatically searches through the bold columns and returns each of the matched values that I need. The first set of data 001-STEN is how I need the formula to operate. My hunch is that its some iteration of an index match formual but I have not been able to...

Hi there, I am looking for a formula that searches through the bold column and returns a corresponding value (I.e Drummin, End Unit, Hardwood Floor etc.) on one single row. This is a sample size of a larger spread sheet and I need the formula to run through the entire document and automatically...

I am working on a monthly menu planner. The dates are merged between three rows in order to allow breakfast, lunch, and dinner meal items each day. The merged cells are causing the calendar to go from Jul 29, Aug 1, Aug 4, Aug 7 (so on, skipping every three days because of the merged cells)...

Dears, I have a big range of data of spare parts where I need to find the right part and press hyperlink to view the picture of the part, is it possible to sort the pictures which linked to a certain Manufacturer or other certain cell related to the part, so if I filtered the excel sheet I can...

Hi All, Bit confused with this. When i exit my macro's and return back to my active sheet my page view is around row 77. how do i get back to showing the top of the sheet ie row 1 i am using the following Sheets("Sheet 1").Select Range("A3").Select the page view is at row 77 and A3 is...

Hi Guys I found a thread with this same question, however my attempt to use the code failed no doubt it is me not the code. I use version 10 and have a user form populate a data sheet on another sheet (sheet 3) named"Bob" is sensitive information. How can I protect that sheet from view via a...

I am using the following code which works really well: Sub CommandButton3_Click()Dim PPApp As PowerPoint.Application, PPPres As PowerPoint.Presentation, PPSlide As PowerPoint.Slide Dim PPPic As Variant Dim wb As Workbook, ws As Worksheet Dim sUser As String, sUserFirst As String, sUserLast As...

Using MS Excel 2010 on Windows 10 I seem to remember seeing an overall view of Named Ranges, in a diagramatic form, for instance, seeing your spreadsheet but with areas outlined, and in different colours, defining the Ranges, with the name of the Range associated with it. I had understood/read...

This is might be the wrong forum but as it might be a vba fix I thought someone might know. I have a custom view set up for my email folders. But every time I create a new folder it set it to the default and I need to manually change it. How can I set up the default to create my view? Or can...

hello, Can you help me to identify and solve my problem? I have multiple textbox in userform and all of it was Vlookup to Combobox1. I arrange the format of each Textbox according to number, percentage and date. it was all good but when i want to edit or change the value in textbox, it doesn't...

Hi Guys! Please help me with my problem about Switchboard. I created my Switchboard with the usual process of creating a simple Switchboard. I used the Default Main Switchboard and i think there is no problem with that if I use that or by creating a new one. Then I input the items on the...

I have a Access DB which I want to upon a successful Login, allow the user to view tables with read or write permissions or both...This is what I have thus far...Any help would be greatly appreciated... Private Sub btnLogin_Click() Dim strCBOPassword As String Dim strPassword As String...

Greetings! I'm currently using excel 2016 in the office previous versions had a feature where you can view changes made to cells on a separate sheet. This would issue the user's name, date, time and cell number change but I don't see feature on the worksheet. Would anyone know where I can find it?

I am trying to make a summary sheet link to other sheets within the workbook via the use of a hyperlink. Within the different sheets, I have certain headings which I would like to link to. The way I have gone about this is to designate the cell with a name and then use that name as the hyperlink...

Hi I have searched high and low for this solution... If I have 4 sheets in a workbook, named Summary, Anne, Jay, Simon. I am looking for Anne to view only her sheet, Simon to view only his sheet, and Jay to view all.... (Their names could be in cell A1 of each of their sheets). How would I do...

My apologies if this has been covered. I have been looking up and down and cannot seem to find what I am looking for. I am trying to scrape data from an internal website that we have. This data can be retrieved by being copy and pasted, but that is a bit excessive. I recall someone...

I have the next VBA code that take to dates and filter all relevant data according to them + move it to new sheet. I want to improve my code and change it to display view instead of static cells at excel sheet (you may see below how the input data looks now). <code>Start time filter: 5/20/2018...