Broken macro button in Excel 2016

.
Have you tried deleting the existing button ... save then close the workbook.

Perhaps even re-boot your computer after that.

Then re-open the workbook and create a new button attached to the macro ?


Ya .. sounds crazy but .. Excel can run you crazy some times.

Originally Posted by Logit

.
Have you tried deleting the existing button ... save then close the workbook.

Perhaps even re-boot your computer after that.

Then re-open the workbook and create a new button attached to the macro ?




Ya .. sounds crazy but .. Excel can run you crazy some times.

Thanks for the suggestion! Unfortunately it didn’t work. I have other form buttons that do work, do I’m not sure what it is about this code that’s causing the problem.

Thanks for the suggestion! Unfortunately it didn’t work. I have other form buttons that do work, do I’m not sure what it is about this code that’s causing the problem.

.
Sorry it didn't work. Not certain what to advise.

You said it works fine from in code but only has an issue when you operate the button .. my first thought is you haven't told the procedure what sheet it is supposed to be on .. the code you provided mentions 2 sheets 'Hide' and 'Main' and you mention this other sheet 'Approved Lenders and Banks' Upon, examining your code in Calculate the first time you 'Select' a sheet is in the conditionals of 'Rate Checker' and/or 'NW Check' but you have code prior to these sections that leave the location in an ambiguous state for example ..when referencing cell locations like in this case 'Clear Textboxs for PHJ and UW Text OutputRange("AJ27:BO34").Value = "" just before clearing this range you do the following ActiveSheet.uprotect "PF2018"Sheets("Hide").visible sheet it is not clear to me which sheet is supposed to have the Range("AJ27:BO34").Value set to "" is it the 'Main' sheet the 'Hide' sheet or is it some other sheet that was the active sheet when you pushed the button?
Hopefully establishing the location in a 'clear' fashion will clear up your issue.

Thank you, I think that may have been part of the problem. I was able to find an earlier version of the spreadsheet that functions in 2016 and determine it is the line that makes the “Hide” sheet visible that was causing the problem. Just removed these lines and now it works.

.
Glad you located the issue.

Cheers !

Happy to see all those hours of chasing down my own issues helped someone.