Macros and Sharing - Limitations?

[TheN]

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.