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