Hi
Very new to vba but i've created a spreadsheet which has several links to hidden sheets in the workbook and a text book vb list box select going on. The problem is when i try and run this spreadsheet from a web page hyperlink it fails to find the hidden sheets. I get the error Run-time error 91 Object variable or with block variable not set. Its highlighting a section of code for a hidden sheet as ActiveWorkbook.Sheets("sheet3").Activate. Is there anyway around this or will i have to show all sheets just to run from a web page?
Many Thanks in advance
Very new to vba but i've created a spreadsheet which has several links to hidden sheets in the workbook and a text book vb list box select going on. The problem is when i try and run this spreadsheet from a web page hyperlink it fails to find the hidden sheets. I get the error Run-time error 91 Object variable or with block variable not set. Its highlighting a section of code for a hidden sheet as ActiveWorkbook.Sheets("sheet3").Activate. Is there anyway around this or will i have to show all sheets just to run from a web page?
Many Thanks in advance
