I have an auto open macro that automatically take you to a sheet, then when you click on continue it will hide the sheet and take you to an index page.
My problem is that all of a sudden, this just stopped working. It started debugging at the 'Sheets("Disclaimer").Visible = True' command. Even when I try to manually set the sheet to visible, I get an error message saying "Unable to set the visible property of the worksheet class"
As I said, I have never had problems with this before, and the model just started doing this for no apparant reason.
Any suggestions would be greatly appreciated.
Thanks
My problem is that all of a sudden, this just stopped working. It started debugging at the 'Sheets("Disclaimer").Visible = True' command. Even when I try to manually set the sheet to visible, I get an error message saying "Unable to set the visible property of the worksheet class"
As I said, I have never had problems with this before, and the model just started doing this for no apparant reason.
Any suggestions would be greatly appreciated.
Thanks