I am using the Shared workbook then Compare & Merge feature to merge user specific columns into my master workbook. 'User specific' means users are allocated their own columns (range = Columns F to Q) to update in their copy of the workbook, eg's. Sue = updates column F only, Bill = updates column G only & so on up to 12 users, thus user 12 uses column Q. Row 1 has their name as the header. The master workbook (ie. the originally 'shared' file) has columns F to Q hidden & then was copied & sent out to each of the 12 users.
When a user opens their copy, I would like the workbook to automatically unhide their named column ONLY. This is because columns A to D need to be visible for each user without horizontal scrolling.
Thus, I ask if this is possible to (a) upon opening the workbook, to prompt for the user name (It would be great if a drop down list presents containing their names but that's not mandatory) (b) to unhide their user specific column (c) active cell to be in row B of their column.