I had a previous thread where the macro unhide a sheet and then hide it once another sheet was activate, is there a way when the button calls the dialog box showing all the hidden sheets of only showing sheets that I want others to access, ie: if there were 5 sheets and I only want them to have access to sheets 4 & 5.
Is this possible, I have tried to do this with the code that is in module 1 but it does not like it?