Hello All
I run/administer a shared workbook that is used by arround 7 users. The users update a numebr of cells, with the rest of the workbook being protected. There are a number of hidden cells within the workbook that are used for calculations.
The problem im having is that for some unknown reason, randomly when a user is going into the workbook all the hidden cells become unhidden. Due to the protection on the sheet there is no way the users can unhide it themself, and they are all opening it from the same location ie not a shortcut.
Does anyone have any clues as to why the workbook (fairly frequently) decides to unhide all the hidden cells.
Cheers
Baskey
I run/administer a shared workbook that is used by arround 7 users. The users update a numebr of cells, with the rest of the workbook being protected. There are a number of hidden cells within the workbook that are used for calculations.
The problem im having is that for some unknown reason, randomly when a user is going into the workbook all the hidden cells become unhidden. Due to the protection on the sheet there is no way the users can unhide it themself, and they are all opening it from the same location ie not a shortcut.
Does anyone have any clues as to why the workbook (fairly frequently) decides to unhide all the hidden cells.
Cheers
Baskey