Macro running on Shared workbook (Sharepoint)
Results 1 to 4 of 4

Thread: Macro running on Shared workbook (Sharepoint)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2017
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Macro running on Shared workbook (Sharepoint)

    Hi everyone,

    Has anyone had any experience of running macros on a shared workbook? I know that array formulas cause shared issues if they are not locked down and protected before sharing it but what happens when I was to run a few macros?

    I have a workbook which will be used on a daily basis by a lot of people. It has formulas that link to external workbooks but these external workbooks are password protected. I have a macro which will remove the password to said workbooks and a macro to limit the way the staff paste into the book.

    Has anyone had any previous experience/Issues with shared workbooks and macros that they could feed back to me?

    Thanks in advance.

  2. #2
    Board Regular sykes's Avatar
    Join Date
    May 2002
    Location
    Cornwall,England
    Posts
    1,560
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro running on Shared workbook (Sharepoint)

    One thing to bear in mind - presumably you've had to hard-code the other workbooks' passwords, into your code; have you protected your actual VBA project - with a password? If not, users will be able to open up your VBA project, and view the passwords.
    Sykes
    Windows 10 / XL 2016
    Members don't have crystal balls, so PLEASE describe your situation, code,
    and requirements ACCURATELY in your first post. It saves hair!
    Better still - upload your spreadsheet (and formulae!) with this great bit of kit.


    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  3. #3
    New Member
    Join Date
    Dec 2017
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro running on Shared workbook (Sharepoint)

    Hi Sykes, Yes i've sorted that side of it too The one thing I'm concerned about mostly is, it kicking other people out and discarding changes. We had an issue on the current workbook where a number of staff were inputting data on completely seperate tabs and it would tell another person that their changes would be discarded. I since discovered that we had some unlocked array formulas that people had been clicking which caused all of these problems.

    I have read somewhere that providing the macros and array formulas are put in and locked down prior to sharing the book then we would have no issues.

  4. #4
    Board Regular sykes's Avatar
    Join Date
    May 2002
    Location
    Cornwall,England
    Posts
    1,560
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro running on Shared workbook (Sharepoint)

    Jolly good.
    Can't provide any more info on sharing issues with array formulae & code, I'm afraid. Hopefully, some other Folk will chip-in...
    Sykes
    Windows 10 / XL 2016
    Members don't have crystal balls, so PLEASE describe your situation, code,
    and requirements ACCURATELY in your first post. It saves hair!
    Better still - upload your spreadsheet (and formulae!) with this great bit of kit.


    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •