Macros and Sharing - Limitations?

**TheN** · 10-13-2016, 06:03 PM

Before I start working on making a mock-up of a sheet I'd like to make run off of three macros, I want to make sure everything is possible to be done with VBA first.

I will want it to:

Create a new Tab and name it right away (will need to be tweaked a few times, 3 iterations in all)
Copy data from one tab, and paste it (as values) into another tab (resorting some columns in the process).
Apply conditional formatting to the page, or color every other line a light grey to increase visibility.
Insert formulas and copy them down for all other data on the sheet.
Look at filtered data (multiple filters) and copy all hidden data to one tab, and visible to another.
Insert page breaks based on a helper column (already have a working macro for this).

One final question is if sharing the workbook will create any issues while running these macro(s). Are there any limitations, such as the amount of users that can be on it at once, if it can be shared in the first place, etc.

I am totally brand new to macros, but have really seen their potential on here, so I am excited to start utilizing them to their full potential. I will update with an appropriate title once I get answers to the above questions.

Thanks in advance.

**TMS** · 10-13-2016, 06:09 PM

1) if you can do something manually, you can do it in VBA

2) sharing workbooks typically presents problems. There are severe limitations as to what you can do with shared workbooks.

**TheN** · 10-13-2016, 08:13 PM

So would I be able to run a macro involving all/some of the above in a shared workbook, or should I first un-share it, then run the macro.

I can still set up the bulk of what I do before the sharing so I will work on making a mock workbook, since you basically told me it was possible. I might just run a single macro if sharing is that much of an issue, and do minor manual manipulations to the shared book.

Thanks.