online

  1. J

    Copy Excel Online Sheet.

    Hello, I'm looking to have a VBA script that will pull a file I have on SharePoint (excel online file) and paste a specified sheet ("AP") onto my workbook "AP". Thanks, Jason
  2. W

    Investing in crypto: excel sheet

    Hello I'm using a value of an external online source in excel, which changes everytime the value on that website changes. This way I can calculate my daily profit or loss (investing). The problem is that, when i'm for example 5 days later, my profits of day 1 change according to the value...
  3. W

    Online changing value: pinning calculated cells

    Hello I'm using a value of an external online source in excel, which changes everytime the value on that website changes. This way I can calculate my daily profit or loss (investing). The problem is that, when i'm for example 5 days later, my profits of day 1 change according to the value...
  4. HeRoseInThree

    Preferred method - advice

    I just got a new company phone and do not want to have to add all of the numbers I need into it individually. I have their information in an Excel spreadsheet - so I was wondering if there was a way to convert XLSX to VCF. I discovered several ways online, but am concerned about putting their...
  5. A

    about offline sharing

    hello evrybody good morning... i have sheet excel ineed to shere it with my stuff to work online and offline anytime and any where plzzz help me??
  6. B

    online based excel?

    i have created a macro based xlsm file and want to know if there some way it can be run online via a web page or something? id like to be able to do it online through my phone if i'm unable to access the pc or basically am i limited to a phone app that cant handle marco versions of excel properly?
  7. M

    Web based SS

    I'm not sure if this is possible to do and reading what I have found so far makes me feel like it isn't but I have to ask anyway. I have a very simple pricing spreadsheet that I would like to put online on my site for clients to use. Is it possible to place a usable spreadsheet on a webpage and...
  8. B

    Online login system - Sheet protection

    So I made a worksheet, and want to start selling it. The thing is, I want to make a login system, making a login system is simple, but the one I want to make an online login system for my sheet, so there can be only 1 user at a time loged in it for a specific login. Is there a tutorial on how...
  9. G

    Command button with macros assigned not working in shared file

    Can someone please help me finding a solution to share an excel file with common buttons and macros with multiple people and allowing them to make changes in real time? I tried using Microsoft one drive excel online but it is very limited so it when I open it the comman buttons are not in the...
  10. R

    Macro to Save as Adobe PDF

    Hello! I am trying to incorporate a button to save a selection to a PDF. If I do it manually, I use the option that says "Save as Adobe PDF". I have tried several different macros online for this and cannot get any of them to work. Any help would be great!
  11. E

    Mod vs And: What's And doing in this Code??

    I get the same answer using MOD as I do using AND with regards to the code below. Note the difference of using 256 vs 255. Could someone explain what the AND is doing, I don't get it and I can't find the answer online. Never seen it used like this before. Just curious. Thanks for your time: r =...
  12. R

    Excel Draw Tools

    Anyone know the code to select the a pen of specific color in the draw tool ribbon? OR point me in the direction online? I can't seem to find anything for this online. I'd like to have a button press select the pen. Thanks in advance!
  13. Karlski

    Sending Excel file via Outlook, is it possible with Outlook online version?

    Hi there, I had a project to create a macro which attaches files into outlook and sends an email. What I created works well using Outlook 2013, but my manager who set me the task doesn't use Outlook program, she uses some online version of Outlook.... Is it possible to add/change the VBA code...
  14. U

    "1" appearing at the end of file name when opened

    Hello, I've created a file which when re-opened seems to open twice and adds a "1" or "2" at the end of the file name. I have five data connections in my workbook, I did have hyperlinks but have since removed. Does anyone know why this is happening and why? I have researched online and some...
  15. R

    Excel-powered collaborative online sheets

    Hello, Please forgive me if this inquiry is in the wrong board here. I have a workbook (3 interconnected sheets) which I would like to be able to present online, wherein the user would be able to fill unlocked cells with data, then save either locally or at the server level. I have another...
  16. F

    permit input but prohibit delete

    Hi All, I want to make a template where it should be possible to add data but it should be prohibited to delete data (not by deleting lines, but also not by deleting data from cells.) I tried to fix it with a VBA code i found online but that doesn't work. Who has the solution? Thanks in...
  17. B

    Connect an Excel Sheet to Online Dashboard

    Hello Guys, Just wondering if anyone out there knows of an easy way of connecting an excel sheet to an online dashboard. I have an excel sheet that gets updated several times a day with daily sales, moth to date and the targets of those figures. I'd like to be able to shows this in a nice...
  18. G

    Pass Spreadsheet into and out of Excel Online without losing macro

    I truly appreciate anyone's help with this. I have scoured forums for days in search of the steps to take. I have a worksheet (a list) with a macro button that sorts the list. I would like to access this list on my phone (excel online), and am fine without the macro function being available...
  19. Aladin Akyurek

    Who's Online

    behaves now differently. Is this intended?
  20. D

    VBA grab pictures from shapes and name as adj cell

    Hi This is a bit complicated to explain but I shall try!!! I receive a price list from a supplier, which contains PartCode,Description and price, it also includes an embedded picture shape of the product (which has generic names e.g. picture069) and a hyperlink embedded in another shape with a...

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