Sheets("Sheet Name").select (not working)

hi all

im trying to stwitch sheets with VBA and when i do the code stops,

Sheets("Sheet Name").select

is the method im using, i can use this exact same method for another sheet within my excel

for example

Sheets("Database").select

will work fine

but Sheets("Sign Preview").select

does not

no matter what i try, iv even renamed the sheet with no effect

the error i get is: Run Time Error '32809': Application-defined or object-defined error.

my buttons that start the code are on user forms.

the code used to work :S and does for other sheets...

how do i solve this / whats caused it to stop working.

regards

Andrew

its definetly the sheets.select that it stops on. but here is my code

Please Login or Register  to view this content.

if i declare the worksheet and workbook, then it will pass this line of code. but then the next lien of code


frmpreviewsign.show gives the same error.

i checked the names carefully even removed spaced and renamed it.

seems the sheet has become Corrupt, the only way to fix it is to remove it, and replace it with a previous version of the sheet.

i think i will just have to rework this all with a previous version of the file.

Hi Andrew,

That happened to me. It's related to the KB 2553154 released from Microsoft, on dec 9th, spoiling ActiveX controls. Even when you apply the MS Fix, workbooks saved in this Excel Versions (2010: 14.0.7140 or 2013: 15.0.4675) don't work. When you use sheets("xxx").select an error occurs, if the sheet has an activeX control. I had to recreat my workbooks.

See http://www.infoworld.com/article/285...root-cert.html

Regards,
Marcelo Rychter