Call function within a worksheet not working when calling another macro from the same workbook, but the macro run ok on its own
I have a workbook for calculating labour rates for either 1no. base location and 1 no. destination i.e only one travel payment or multiple multiple base locations and multiples destinations. but I only want to show the relevant worksheets for either one of the two previous options. I have created macros to hide and unhide worksheets and these work successfully on their own. There are a total of 4 variations i.e
Electrical – Single site
Electrical – Multisite (there are 12 sheets that this macro hides)
Mechanical – Single site
Mechanical – Multisite (there are 12 sheets that this macro hides)
Call is waiting [closed]
Closed 1 min ago.