Sheet Switching Macro Bug

I seem to have stumbled upon an excel bug which stops my sheet switching macros from working. If I hide the tab which leads to the sheet, the macro which links to that sheet also stops working. I do not have any apparent knowledge of how to resolve this issue unless there is a different code somewhere which can keep the macros working even when the sheet tab has been hidden

Checkbox creation

Currently, I am looking for a way to insert checkboxes into excel and use them as a form of conditional formatting for one of my worksheets. I'm still looking for a way to do this. A bit of VB coding will be neccessary, buti t will take some time finding a suitable code

CLEANUP - EDIT: It is possible through excel to get checkboxes. You have to get into the options and tick the "Show Developer tab in ribbon" box. Through the developer box, you can do a few more expert features, including adding checkboxes. Unfortunately, I can't use any of the other features do to my novice knowledge and the checkboxes don't move when you increase/decrease the cell since you can't embed them into the cells.
It would of been great if you could embbed checkboxes into cells but manually moving them works just as well. Takes a hell of a long time but still works

Drop Down-List Creation

I find that the drop down list creation in Excel 2007 is very irritating. To create the options, I have to put them somewhere and then use them as a source. Deleting the cell with this Source Data is held clears out the options. The way around this is to put this source data somewhere out of the main page but then I have random words in the middle of nowhere in the dataspace.

CLEANUP - EDIT: I found a method with works just as well. Type the data you want in the drop down list somewhere which your not going to use (not too far away from your data or else when you print, your gonna have a load of blank papers and a very small data area) and then, change the font colour to match your background.
Presto, your drop down options are there when you click the arrow but no where to be seen on your workplace

"ThisWorkbook.Close" Excel Error

The "ThisWorkbook.Close" line under the "ActiveWorkbook.Save" seems to work for al imited time. After a few tries, the error comes back and keeps coming. The only resolution is to add the "Application.Quit" line although it closes ALL active workbooks. It must be a replacement until I am able to find a way around this

Save & Exit VB Code

I've finally got a code which saves and exits the excel worksheet without an error. All I had to do was use a close command after the save command (for a macro I had already created which saved the system)
Now the macro saves and exits the workbook with no problems.
Onto creating the fields!