I need to create a macro that moves the user to a specific sheet depending on the value they enter into a specific cell.
However, when the file is sent to a client, the client must not be able to view worksheets containing calculations - these must remain hidden.
Do you know a way of hiding them that will still allow the macro to work?
Any advice appreciated.