Hi all and thanks in advanced for helping!
Is it possible to designate a cell to ignore changes and have no prompt when using a shared worksheet?
Here is my scenario:
I have a VB macro that pulls the specific username of the current user, it puts this data into a single cell on one page. This cell determines what is visible for the user (like a filter and other data that is formula based). However, if multiple people are in the spreadsheet at the same time, and save it, they get a conflicting changes prompt asking which changes to keep and to discard as they both "made changes" to the same cell.
Is there a way to have a cell totally ignored and never saved? The macro runs on the load of the spreadsheet, and dynamically changes the cell for each person. The formulas are static and dont change but are based on this cell.
Alternatively, is there a way to use VB variables in a cell formula without putting that data into a cell?
Thanks!
Bookmarks