view

  1. G

    Switching to Datasheet view in Sharepoint

    Hello, I have been searching the internet , but unable to find the answer... I have a sharepoint list which displays perfectly in Standard view, if i try and switch to Datasheet view , I just get a blank grid. I have asked colleagues to try and they get the normal excel/access grid format...
  2. B

    Why is VBA combining new macro code with current macro code?

    I have 2 separate macros in an Excel file. If I click on one and "edit" it will bring up only the code for that macro. I'm trying to create a new macro in the file, but every time I try to create the new macro and view the code, it also pulls up one of the current codes with a "divider line"...
  3. G

    Protected view

    Hello, I have a file I update it every week and send it to my managers and colleagues.Recently I get a message of protected view, andI have to choose "Enable Editing" to do my data entry. It always happens when I get a “save as” or renamemy file. My problem is with inserted comments. I hide my...
  4. J

    Form Password & Hide Different View Options

    Hello, Is there a way to password protect a form and also hide the different viewing options of the form. I only want the user to be able to see the form view not design and database view. Is this possible? Thanks!
  5. E

    view page source

    Hi Is there a way to get the webpage xml (right click on a webpage and - view page source) ? tnx
  6. A

    Form View doesn't match Design View - Forced to Scroll When Unnecessary

    Hi all, I've been studying form properties, and can't find what is causing this issue. In Design View, all my buttons can be seen on a single page without the need to scroll. When I open up the Form View, there is a large bar of whitespace where my bottom buttons should be ... I can scroll...
  7. X

    Show Custom View Using VBA Varaible

    Hi, Problem, I wanted to consolidate my VBA so every button used the same macro. The below doesn't seem to work when I use the variable ButtonText to call the custom view, but works fine if I type it manually, eg. "Total" which is one of the views I can to show. 'Define variables Dim ws...
  8. W

    Formula help

    Hi all, I'm wondering if anyone can help with a formula:confused: In cell G3 I would like a total of column C, but only for X911/C (column B)
  9. P

    VBA Looping through Links on Website

    Hi All: Been struggling all day to write some VBA to loop through links on HTML site but keeps failing and showing error code 0. Please help!! I have the following: Set HTML = ie.document Set ElementCol = HTML.getElementsByClassName("ViewLink") For Each link In ElementCol If link.innerText...
  10. E

    Excel Calendar

    Hey everyone I had a quick question regarding an excel calendar...You can download my file here: https://drive.google.com/open?id=1rst5mp7<strike></strike> Download it and click on the 'monthly view' sheet...What Im trying to figure out is once you click on monthly view in the Cell "M" add...
  11. D

    [VBA] working with Share Point

    Hello. Today I got a task to work with MS Share Point through Excel. This is not a simple upload to a specified location. It's more complicated, at least for me. The upload appears as completely new file in the same view but when I right click mouse on a file I can go to the whole history of...
  12. M

    "Custom View" Changes Views on a Workbook with Multiple Tab's/Sheets

    I am using "Custom View" to help users of a shared a Workbook to sort and filter data quickly on a large data table with Multiple Sheets. The Workbook is a Scheduler what uses Status Codes to sort Sales Order by STATUS and Customer SHIP DATE. The problem is when I ADD a Custom View on Sheet 3 it...
  13. E

    VBA/Option to Open and Restrict a Spreadsheet to Open Only in Full Screen View

    Hi, I was wondering if there is an option/VBA code/steps that will automatically open a spreadsheet in full screen view and restrict users from toggling with the view unless a password has been entered. Pretty much the users will be using the spreadsheet only in full screen view while the...
  14. E

    Multiple Users/Passwords to view but not edit specific sheets

    I have been working on getting a workbook together to track our time off at our office. I have run across several posts about having multiple users/passwords to be able to hide/unhide sheets and have that going pretty well in my workbook so far. My question is - is there a way to protect the...
  15. D

    I'd Like to Switch From "Print View" to "Normal View"

    Hi all, Forgive me if I'm violating any forum rules: I'm new to this site and posting on forums in general. I've read the rules of this, I've searched through many SOLVED threads, and I still have a question. I really hope you guys can help. I'm working on a couple of sheets in Excel 2016, and...
  16. B

    CommandBars.FindControl(ID:=)

    I am looking for the Control ID for table cells. I am trying to enable a right click for a SubMenu; I already have 'cell' and ID:=1588 for the Page Layout view, but can't seem to fine the ID for a cell in a table.
  17. T

    Blank Excel 2013 worksheets

    When I open an Excel file (Office 2013) the worksheets all display as empty worksheets. If I uncheck 'formula bar; under View, then the worksheets in the file all display normally. I can then re-check the formula bar view and everything is fine until I close and re-open Excel. Anyone have an...
  18. H

    How to calculate Contribution using DAX - Complex Business Problem - Please help

    SQL View: a view created from SQL query from different tables Unpivot SQL View: and unpivot version of table created in point 1 through power query Report : Desired presentation Objective: adding contribution column next to sales column where contribution is total sales - total prime cost...
  19. A

    PowerPivot SQL Datasource Added Fields

    Hi All, I have a PowerPivot linked to a SQL database view. I use it successfully in PowerPivot w/Excel 2016. Recently there have been additional columns added to the SQL view. I thought they would automatically appear in my PowerPivot data when I refreshed but they do not. Any suggestions? I...
  20. D

    Help with interface

    Today I somehow manged to get a popup window to open that appears to format a particular chart. I have no idea how I opened it, nor how I can get it closed. It stays up on top of everything and anything...different sheets, different menus etc. Can someone tell me A) how did I cause this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top