Macro running on Shared workbook (Sharepoint)

Kirstym1918

New Member
Joined
Dec 17, 2017
Messages
45
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. :biggrin:
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,649
Office Version
365
Platform
Windows
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.
 

Kirstym1918

New Member
Joined
Dec 17, 2017
Messages
45
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.
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,649
Office Version
365
Platform
Windows
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...
 

Watch MrExcel Video

Forum statistics

Threads
1,099,261
Messages
5,467,638
Members
406,545
Latest member
puneet829

This Week's Hot Topics

Top