Posted 8 September 2017, 3:17 pm ESTFpSpread1.Sheets(1).Visible = False;
If I have a sheet that I do not want the users to see I can use the Visible property. However, I am having issues when using this.
I have a sheet that has calculated data that is displayed on the main sheet. I want the users to interact with the main sheet without seeing the sheet that has the calculations on it. When I set this sheet Visible to false my program will crash when interacting on the main sheet.
If I set visible to true on the calculation sheet everything works.
Is there a mechanism that allows me to block access to the entire sheet that will still allow it to function?