Hello everyone...I have a macros in worksheet not allowing my button macros fully function

**lbillie** · 10-02-2013, 04:08 PM

I have a macros to hide and unhide my "Contra_submittal" sheet based on a cell value. On my "Checklist" sheet, I created a spread sheet using checkbox applications. I also applied a macros button to my "Checklist" sheet. By clicking on the macros button it's suppose to opens 2 files to retrieve formulas, pictures, and results depending on the check box selection. It gives me a Run-time error '9' Subscript out of range message. The macros button does not fully function. It only opens 1 of the 2 files. I click on Debug to find the error. The formula below is my hide and unhide macros, which I don't think has anything to do with my button macros. Worksheets("Contra_submittal").Visible = xlSheetVisible is highlighted. When I remove the macros shown below, my button macros works very well, but I really need the formula below to hide a sheet if it's not needed. It only happens to buttons with a macros that opens files. Gratitude to anyone who can assist me. I hope my explanation is clear. The macros below is under my "Contra_submittal" sheet.

Formula:

Please Login or Register  to view this content.

**protonLeah** · 10-02-2013, 09:05 PM

The Err 9 seems to be saying that the sheet wasn't found in the active workbook. Try adding the name of the workbook containing that sheet:
Workbooks("book_name").Worksheets("Contra_submittal").Visible = xlVeryHidden