view

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...

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"...

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...

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!

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

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...

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...

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)

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...