SaveAS Error

[tigerdel]

I have tried to get the below code working but I have obviously done something wrong as although I get no error messages I am not getting the second part to trigger

The first part does what it should do bit the second part doesn't trigger the msgboxes

Any ideas what I am doing wrong??

Please Login or Register  to view this content.

[mshale]

You just needed to end your if statements propperly

Please Login or Register  to view this content.

[tigerdel]

Clinic TNA WIP.xlsbThanks for the speedy response but this still doesn't work

As there is no real sensitive data in this file, I have uploaded it

If you click start at the home page and then click the finish button, you will now see it does nothing but select cell BB1

Any help here great appreciated

[mshale]

I'm not sure why, It works just fine stepping through it with a test sheet. I'm leaning more toward the possibility of another snipet of code that is causing an error.

Opening your sheet you just uploaded is a nightmare. It opens the document twice and tells me that the sheet is locked for editing and a few other wierd things.

I also had to change "TRUE" to "True" in your original code to get it to work at all for me. I have changed it back to caps so you might want to try the above again.

[tigerdel]

I noted the change of case for True and False and changed them back to TRUE and FALSE

Now id it says TRUE the script works perfectly but not if it says FALSE

Strange or what??

[tigerdel]

I sussed it

Thanks this now works perfectly

Problem solved

[tigerdel]

mshale you truly are a star

[tigerdel]

OK so how do I mark as solved??

[mshale]

What did you find wrong with it?

To mark as "Solved", all you need to do is click "edit post" on your first post. to the immediate left of where your thread title is, you should see a prefix selection. Just select solved, and then save near the bottom of the post.