Hi, I have an excel report that I'm building in which I have a Sheet for 'Checks' where data is validated with conditional formatting with a tick or a cross against the various report related items.
It extends over 7 rows- Column A contains the list of line items and column B contains the validation 'ticks/crosses'. I need a macro that reads the ticks in column B & hides the sheet automatically possibly with a 'password protection'.
But if there is a 'cross' against even one item in the sheet, it prompts the user to 'Check that all fields/data has been entered corectly'. And once the data has been populated correctly hide & protect the sheet again and go to the MAin Report Page - first cell. Any help with this will be appreciated !