OT- Any Excel Whizzes on here?

Discussion in 'Bulletin Board' started by TitusMagee, Nov 22, 2022.

Page 2 of 2
  1. barnsley66

    barnsley66 Well-Known Member

    Joined:
    Jul 18, 2005
    Messages:
    4,027
    Likes Received:
    572
    Trophy Points:
    113
    Occupation:
    Learner Support Assistant/Happy Clapper
    Location:
    Doduth
    Home Page:
    Style:
    Barnsley (full width)
    If only certain people need to see it, password protect it and only tell them the password.
     
    barnsley66, Nov 22, 2022
    #21
  2. MDG

    MDG Well-Known Member

    Joined:
    Jul 21, 2005
    Messages:
    5,813
    Likes Received:
    4,322
    Trophy Points:
    113
    Location:
    Wilthorpe
    Style:
    Barnsley (full width)
    If it's already got macros, write another which triggers on the On workbook open event. Capture the windows user logon that way.
     
    MDG, Nov 22, 2022
    #22
    TitusMagee likes this.
  3. Jay

    Jay Well-Known Member

    Joined:
    Jul 18, 2005
    Messages:
    43,089
    Likes Received:
    31,463
    Trophy Points:
    113
    Location:
    On Sofa
    Style:
    Barnsley
    Jay, Nov 22, 2022
    #23
    TitusMagee likes this.
  4. nezbfc

    nezbfc Well-Known Member

    Joined:
    Sep 13, 2005
    Messages:
    10,989
    Likes Received:
    6,660
    Trophy Points:
    113
    Style:
    Barnsley (full width)
    Fair shout. Although can't the user still "disable" any macros as it generally prompts before opening...

    I suppose he can always password protect a macro so it isn't accessible, and couple that with Jay's email suggestion could work, but maybe defeats the object if they can disable them upon open anyway....
     
    nezbfc, Nov 22, 2022
    #24
  5. JamDrop

    JamDrop Well-Known Member

    Joined:
    Mar 30, 2013
    Messages:
    18,594
    Likes Received:
    19,465
    Trophy Points:
    113
    Location:
    Leeds
    Style:
    Barnsley (full width)
    Write a message on it saying ‘sod off X, haven’t you got your own work to do’?

    If they’re not changing it or using it in any way, would your work even be bothered? It wastes a few minutes of their time I suppose but they could just say they’re trying to get a better understanding of your role in case a job comes up again. Unless they are doing anything malicious with it (need more info on how they have caused problems in the past), I don’t think anyone will care.
     
    JamDrop, Nov 22, 2022
    #25
    MDG and TitusMagee like this.
  6. TitusMagee

    TitusMagee Well-Known Member

    Joined:
    Apr 2, 2018
    Messages:
    8,778
    Likes Received:
    13,611
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Silkstone Common
    Style:
    Barnsley (full width)
    TitusMagee, Nov 22, 2022
    #26
  7. TitusMagee

    TitusMagee Well-Known Member

    Joined:
    Apr 2, 2018
    Messages:
    8,778
    Likes Received:
    13,611
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Silkstone Common
    Style:
    Barnsley (full width)
    Yeah theres a lot more to it, this is the equivalent of nailing Al Capone for tax evasion, it isn't the main issue :)
     
    TitusMagee, Nov 22, 2022
    #27
    JamDrop likes this.
  8. JamDrop

    JamDrop Well-Known Member

    Joined:
    Mar 30, 2013
    Messages:
    18,594
    Likes Received:
    19,465
    Trophy Points:
    113
    Location:
    Leeds
    Style:
    Barnsley (full width)
    Do you know when they are looking at it? Is it during work time/on work premises or can they remote in?
     
    JamDrop, Nov 22, 2022
    #28
  9. t'owd man

    t'owd man Well-Known Member

    Joined:
    Sep 19, 2006
    Messages:
    2,022
    Likes Received:
    1,226
    Trophy Points:
    113
    Occupation:
    Skivvy for r lass
    Location:
    Tarn
    Style:
    XenForo - Xenith Reds
    Tek im behind t'bike sheds and leather im.
     
    t'owd man, Nov 22, 2022
    #29
    Stephen Dawson, MDG and TitusMagee like this.
  10. TitusMagee

    TitusMagee Well-Known Member

    Joined:
    Apr 2, 2018
    Messages:
    8,778
    Likes Received:
    13,611
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Silkstone Common
    Style:
    Barnsley (full width)
    No not sure, but could do it remotely.
     
    TitusMagee, Nov 22, 2022
    #30
  11. Stephen Dawson

    Stephen Dawson Well-Known Member

    Joined:
    Apr 25, 2018
    Messages:
    36,205
    Likes Received:
    30,974
    Trophy Points:
    113
    Gender:
    Male
    Style:
    Barnsley (full width)
     
    Stephen Dawson, Nov 22, 2022
    #31
  12. MDG

    MDG Well-Known Member

    Joined:
    Jul 21, 2005
    Messages:
    5,813
    Likes Received:
    4,322
    Trophy Points:
    113
    Location:
    Wilthorpe
    Style:
    Barnsley (full width)
    In the days when we had desktop PC's in our office not laptops.

    Once put a fun little bit of code on a file I sent to my boss. I guess you could call it a harmless fun virus. Just a simple macro that whe he opened the file, it copied some vba to his personal macros.

    Then everytime he opened excel the macro triggered and started opening and closing his cd tray.

    Only a bit of fun as we used to wind each other up but it just shows how vulnerable your machine can be just by allowing all macros.

    :D
     
    MDG, Nov 22, 2022
    #32
    TitusMagee likes this.
  13. Gally

    Gally Administrator Staff Member Admin

    Joined:
    Nov 5, 2009
    Messages:
    17,040
    Likes Received:
    12,611
    Trophy Points:
    113
    Location:
    York
    Home Page:
    Style:
    Barnsley
    As MDG mentions, you could use a macro and specifically the Workbook.Open() event to track who opens it. There's a thread here that discusses how it can work. It would be dependent on the person not blocking macros at run time though

    https://answers.microsoft.com/en-us...my-excel/fe1bcb6d-c5d2-44b3-b1d2-d51c6a1a375b

    Some file storage stores the last accessed date.

    If you move the file to SharePoint Or Teams (which uses SharePoint to store date) then you could get the access details from the M365 audit logs. (you'd probably need to ask your admin).
     
    Gally, Nov 22, 2022
    #33
    TitusMagee likes this.
  14. Jaffa

    Jaffa Well-Known Member

    Joined:
    Jul 20, 2005
    Messages:
    2,463
    Likes Received:
    38
    Trophy Points:
    48
    Location:
    Tarn
    Style:
    Barnsley (full width)
    define what users can open what file on the file.

    if its the formulas they are looking at, you can lockdown cells so that it is blank unless you are a certain user as well.

    If in sharepoint you can allow certain people to access certain folders/files.
     
    Jaffa, Nov 22, 2022
    #34
    TitusMagee likes this.
  15. Stephen Dawson

    Stephen Dawson Well-Known Member

    Joined:
    Apr 25, 2018
    Messages:
    36,205
    Likes Received:
    30,974
    Trophy Points:
    113
    Gender:
    Male
    Style:
    Barnsley (full width)
     
    Stephen Dawson, Nov 22, 2022
    #35
Page 2 of 2

Share This Page