VBA in shared workbooks

[Sir Babydum GBE]

Hi

I'm creating an Excel 365 workbook, saved on a shared OneDrive. Up to four people may use it at the same time.

I want to create a macro that will hide or unhide certain rows according to each user's choice, but im wondering whether when the macro is executed on the one PC, it will immediately hide/show those rows for other users working on it at the same time? (i'm hoping not but suspecting otherwise)

Thanks

[Logit]

.
I've never tried that but suspect you are probably correct.

Why not create a small workbook with no data except the hiding of the rows and test it.