Boiler Guy
01-13-2020, 06:28 PM
I have searched for hours now for a solution to this. There are a LOT of examples of how to do this online and I have tried many. They all seem to work for everyone else but everything I try gives me the same error: Runtime Error 9.
I attached a copy of the file to this post. Could someone show me how to use the hyperlinks on the main sheet to un-hide the hyperlinked sheet?
Also, would it be possible to have it delete all the other sheets after selecting which page you want from the hyperlink?
I am using this for boiler maintenance sheets. After selecting which sheet I want to use it would be nice if it could delete all the other ones so when I send it to the customer there aren't other sheets hidden in the background (obviously it would be read-only and have to be saved with a different name so as to not destroy the original).
Any help is much appreciated. Thank you!!!
I attached a copy of the file to this post. Could someone show me how to use the hyperlinks on the main sheet to un-hide the hyperlinked sheet?
Also, would it be possible to have it delete all the other sheets after selecting which page you want from the hyperlink?
I am using this for boiler maintenance sheets. After selecting which sheet I want to use it would be nice if it could delete all the other ones so when I send it to the customer there aren't other sheets hidden in the background (obviously it would be read-only and have to be saved with a different name so as to not destroy the original).
Any help is much appreciated. Thank you!!!