Hiding and un hiding columns using VBA code

Hi

I'm really trying to get in the swing of this VBA thing but I think I'm starting in the middle rather than at the beginning so making some simple errors. I've only just started using google to find the things I want to do an adapting it so I don't have any training yet but i'll get there.

I need a code that will allow a button to unhide a set of columns when pushed with a password and then hide again.

I have come up with this

Please Login or Register  to view this content.

At first it was working OK - you could enter the correct password and it would unhide the columns and change the button name. However, if you entered the password wrong it disables the button permanently (instead of just closing the message box and not unhiding the columns). You also need to enter the password to hide the columns which is not needed.

Maybe I need two buttons but it would be quite nice to just have the one!!!

However, something in my table has changed - I removed the total row and added a new Sub to automatically enter a date when a booking was made. Now I get the error "Unable to set the hidden property of the range class"

Any help would be appreciated for this VBA total novice :-)


Many thanks

Alphafrog`s code is more complete then the following,

but since its done, ill post it any ways

Please Login or Register  to view this content.

This works perfectly

Thanks so much for taking the time to help!

Jes